Q

Taking backup of table structures without content

What is the command to export only the schema without the database in Oracle9i? I want to take a backup of the table structure only, not the contents of the table. We have nearly 500 tables in our database.

What is the command to export only the schema without the database in Oracle9i? I want to take a backup of the table structure only, not the contents of the table. We have nearly 500 tables in our database.
Try the following:
exp userid=system owner=scott rows=n file=scott.dmp
The OWNER clause denotes the schema you want exported. Only those schemas listed will be in the dump file. The ROWS=N clause tells Oracle not to dump any rows of data. The table structure will be exported but no actual data will be found in the dump file.
This was first published in June 2006

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close