Home » RDBMS Server » Server Utilities » Data Pump Import - how to identify Dump file's tablespaces (Oracle Database 11g Release 11.1.0.7.0 - 64bit Production)
Data Pump Import - how to identify Dump file's tablespaces [message #559710] Thu, 05 July 2012 13:05 Go to next message
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 #559712 is a reply to message #559710] Thu, 05 July 2012 13:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Import the metadata (DDL) into a file and then you can see what are the used tablespaces.

Regards
Michel

[Updated on: Thu, 05 July 2012 13:12]

Report message to a moderator

Re: Data Pump Import - how to identify Dump file's tablespaces [message #559713 is a reply to message #559712] Thu, 05 July 2012 13:25 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/m/559599/136107/#msg_559599
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 Go to previous message
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

Previous Topic: How to upload photos in oracle database
Next Topic: ORA-22303
Goto Forum:
  


Current Time: Thu Mar 28 17:35:52 CDT 2024