Trouble with expdp and impdp with schema
Hi,
Hope someone can help me...
I'm having problems with the following scenerio:
I do an "expdp test/test schema=test directory="/testoutput/" parallel=8" ...
Now, when I do an "impdp test/test dumpfiles=test01.dmp, test02.dmp...test08.dmp nologfile=y" I get an -12889 error.
In the past with exp/imp, you can create the table structures and then import the metadata over, but with data pump, I'm finding it more difficult.
Here's what I would like to accomplish, I have 2 potential scenerios:
1. Using datapump I want to export this "test" user schema completely.
- The dilemma is the tablespaces the test user tables are matched up to are not on the target database, I would like to REMAP_TABLESPACES all to the default tablespace. The impdp initially complains that TABLESPACE "XYZ" does not exist and errors out for all the tables.
Hope someone can help me...
I'm having problems with the following scenerio:
I do an "expdp test/test schema=test directory="/testoutput/" parallel=8" ...
Now, when I do an "impdp test/test dumpfiles=test01.dmp, test02.dmp...test08.dmp nologfile=y" I get an -12889 error.
In the past with exp/imp, you can create the table structures and then import the metadata over, but with data pump, I'm finding it more difficult.
Here's what I would like to accomplish, I have 2 potential scenerios:
1. Using datapump I want to export this "test" user schema completely.
- The dilemma is the tablespaces the test user tables are matched up to are not on the target database, I would like to REMAP_TABLESPACES all to the default tablespace. The impdp initially complains that TABLESPACE "XYZ" does not exist and errors out for all the tables.
0