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.

    Requires Free Membership to View

    Login

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

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top