Import a tablespace from export file
I'd like to import a tablespace from export file. Is it possible?
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