Home » RDBMS Server » Server Utilities » Missing objects during datapump import (AIX, Oracle 10.2.0.2)
Missing objects during datapump import [message #507792] Wed, 18 May 2011 00:27 Go to next message
lg123
Messages: 225
Registered: August 2008
Senior Member
I did the datapump export and import from one schema to a new schema in the same database. I had to use different tablespace. I used the following parameters in the parfiles :

export parfile
directory
dumpfile
logfile
parallel


import parfile
directory
dumpfile
logfile
parallel
remap_schema
remap_tablespace

Can someone tell me whether I need to use different parameters than the one I used?

Can I use both remap_schema and remap_tablespace at a time?
Re: Missing objects during datapump import [message #507797 is a reply to message #507792] Wed, 18 May 2011 01:02 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Can someone tell me whether I need to use different parameters than the one I used?

Why not "parallel" in import?
"include", "exclude" depending on what you actually want.

Quote:
Can I use both remap_schema and remap_tablespace at a time?

Yes.

Regards
Michel
Previous Topic: sqlloader doesn't work
Next Topic: Backup through Batch file.
Goto Forum:
  


Current Time: Fri Mar 29 03:02:10 CDT 2024