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

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

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