Ask the Expert

Import a tablespace from export file

I'd like to import a tablespace from export file. Is it possible?

    Requires Free Membership to View

An export dump is a "logical" backup, not a physical backup. Since a datafile is a physical implementation of your database, you will not be able to import this physical implementation from the logical backup.

You can import the contents of a tablespace with the TABLESPACES parameter. For instance, use the following command to import all segments that belong to the USERS tablespace:

imp userid=system file=my_dump.dmp tablespaces=users

This was first published in March 2005

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: