Author: kamus
Mail: kamus@itpub.net
Date: 2004-1
Often someone will ask: The original data is in the user table space, I want to put it into the app table space, I have modified the destination user's default table space, why is the result or IMP to the UserS table space.
For this issue, as explained below:
Oracle does not provide any parameters to specify which tablespace to import, the data will be imported into the tablespace where the data is located when the data is imported, but we can implement the import to different tablespaces by the following methods.
1. Use indexfile parameters at IMP
When a file name is specified for this parameter, all INDEX will not be imported into the table space directly, but generate an index script in the specified file.
Then open this file with a text editor, edit the Storage parameters in the script, modify the table space name you want to import.
Then re-execute the IMP, use the indexs = n parameter to import Objects other than INDEX.
Finally, enter SQL * Plus, run the script just edited, generate an index.
This method is suitable for importing Index and Constraints into the specified tablespace.
2. Change the default table space of the destination user
This is the method that is often questioned by it. However, the above problems is not successful because the following steps are missing.
First, the "unlimited TableSpace" permission to collect the purpose:
Revoke Unlimited TableSpace from UserName;
Second, the destination user deduces the quota in the table space in the original data, so that IMP will import data into the user's default table space.
Then, the table space you want to import will then be set to the default table space of the destination user, and add a quota.
Finally, IMP is executed.
3. Use Toad
Toad is a powerful Oracle database management software. It is a third-party software for Quest. We can use the Rebuild Multi Objects tool to implement multiple Object to the specified tablespace.
So we could no matter how three seven twenty-one, first IMP, and then modify it after you.
About TOAD use, this is not explained in detail.
