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.

Dig Deeper on Oracle database backup and recovery

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close