"Bo Main Note: Database aspects itpub website and blog content is very rich and informative"
Reprint Source Itpub Blog
Often people will ask: the original data in the Users table space, I want to put it into the app table space, I have modified the target user's default tablespace, why the result is the IMP into the Users table space.
For this question, make the following explanation:
Oracle does not provide any parameters to specify which table space to import, and data is imported by default into the table space where the data was originally exported, but we can implement the following methods to import into different tablespaces.
1. Using the Indexfile parameter in imp
when a file name is specified for this parameter, all index will not be imported directly into the table space, but the script to create the index is generated in the specified file.
then open the file with a text editor, edit the storage parameter directly in the script, and modify it to the name of the tablespace you want to import.
then re-execute the IMP, using the Indexs=n parameter to import objects other than index.
Finally, go to Sql*plus, run the script you just edited, and build the index.
This method is useful for importing index and constraints into the specified tablespace.
2. Change the default tablespace for the destination user
This is the way that people often ask questions. But the problem is not successful because of the lack of the following steps.
first, recover the "UNLIMITED tablespace" permission for the destination user:
revoke unlimited tablespace from username;
Second, cancel the quota of the destination user in the original data export table space, in order to force IMP to import the data into the user's default table space.
then, set the table space you want to import as the default tablespace for the destination user, and add quotas.
Finally, the IMP is executed.
3. Using Toad
Toad is a powerful Oracle database management software that is a third-party software produced by Quest, and we can use the Rebuild Multi objects tool to move multiple objects to a specified tablespace.
so we can no matter 3,721, first imp, and then use Toad for the subsequent modification.
the use of toad is not explained in detail here.
Oracle Tips _ Different table space different user import and export data dmp
