Home » RDBMS Server » Server Utilities » How to read content from a datapump file (Oracle 10g, AIX)
How to read content from a datapump file [message #340594] Wed, 13 August 2008 06:27 Go to next message
Cowon_d3
Messages: 6
Registered: August 2008
Location: Norway
Junior Member
Hi,

I want to know what is inside a exported file from datapump. I'm especially looking for what the name of the tablespace for certain schemas is since I will use remap_tablespace when I import.

I know I can use Grid Control, but want to know if it is possible with impdp, or a PL/SQL script.

Thanks in advance!

Re: How to read content from a datapump file [message #340611 is a reply to message #340594] Wed, 13 August 2008 07:31 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

You can do dummy import with SQLFILE parameter with IMPDP
SQLFILE               Write all the SQL DDL to a specified file.


eg: impdp username/pwd DIRECTORY=name DUMPFILE=name SQLFILE=path

Re: How to read content from a datapump file [message #340618 is a reply to message #340594] Wed, 13 August 2008 07:55 Go to previous message
Cowon_d3
Messages: 6
Registered: August 2008
Location: Norway
Junior Member
Thanks a lot. Exactely what i was looking for Smile
Previous Topic: DBMS_DATAPUMP
Next Topic: How to load the flat files to the oracle database?
Goto Forum:
  


Current Time: Thu Dec 08 10:31:24 CST 2016

Total time taken to generate the page: 0.20957 seconds