| Data Pump Import - how to identify Dump file's tablespaces [message #559710] |
Thu, 05 July 2012 13:05  |
Andrey_R
Messages: 441
Registered: January 2012
Location: Israel
|
Senior Member |
|
|
Hi all,
I'm rying to import schema's from a dump file that came from a different environment.
What I have is:
1. dump file
2. log file of the export
I'm trying to import the file(containing three schemas) with remap_schemas,
and it fails, gives a lot of ORA-00959: tablespace 'string' does not exist.
Now, I've read in OTN:
https://kr.forums.oracle.com/forums/thread.jspa?threadID=1065737
that what you need to do in that case is to use the REMAP_TABLESPACE option,
to redirect the objects to a different tablespace.
I don't see a name of the tablespace I'm getting the error for in the export log.
I don't know if I have more tablespaces I have to redirect with REMAP_TABLESPACE.
I don't want to perform this 3 times, have an error,
by that find out what's the next tablespace needing redirection and only then starting over...
My question is:
How can I know from the dump file and the log file,
what is the tablespace names i need for the redirection to my names?
Or its just that the tablespace giving me the error is the only one in the dump file?
Please help..
Regards,
Andrey
|
|
|
|
|
|
|
|
| Re: Data Pump Import - how to identify Dump file's tablespaces [message #559721 is a reply to message #559713] |
Thu, 05 July 2012 13:56  |
Andrey_R
Messages: 441
Registered: January 2012
Location: Israel
|
Senior Member |
|
|
No need to be mean..
I even *know* of that option but didn't consider using it to find out the names of tablespaces.
I guess it's been a long day. With your hint - I could make the link.
(Doesn't mean I'm stupid or lazy... You've helped me, don't feel bad about it.)
Thank you for your help.
Regards,
Andrey
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
