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

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: