Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Alternative to remap tablespace during import?

tjohnsonFeb 24 2009 — edited Feb 24 2009

I am working part of a larger project where we are merging two databases.

We have 10g standard. I've been asked to export a schema (ABC) using the old exp utility which worked fine and I sent it on to the other location where the merge is going on.

At our location I'd like to refresh one of our test databases with that export for other testing. The test database uses a different schema name (XYZ). It has two table spaces, XYZ_DATA and XYZ_INDEX. The source has ABC_DATA and ABC_INDEX. Normally when I export using EXPDP I use the 10g IMPDP to import I can REMAP_SCHEMA=ABC:XYZ AND REMAP_TABLESPACE=ABC_DATA:XYZ_DATA, ABC_INDEX:XYZ_INDEX

I did use fromuser=ABC and touser=XZ to remap the schema. I don't see any way to remap tablespace. If I have a schema XYZ and create tablespaces ABC_DATA and ABC_INDEX will the export import to those tablespaces respectivley and would I be able to rename ABC_DATA to XYZ_DATA and ABC_INDEX to XYZ_INDEX?

Any thought/comments/suggestions?