I don't know how to export a tablespace in Oracle9i. Can you help? I want step-by-step instructions?

    Requires Free Membership to View

    Login

If you want to create an export dump of a tablespace's contents, then use the 'exp' utility as follows: 
exp userid=system/manager file=my_ts.dmp log=my_ts.log tablespaces=ts1
As you can see, I used the TABLESPACES clause. You can denote multiple tablespaces in that clause by separating the tablespace names with commas similar to the following: 
tablespaces=ts1,ts2,ts3

This was first published in April 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