OraFAQ Forum: Server Utilities » How to read content from a datapump file

Home » RDBMS Server » Server Utilities » How to read content from a datapump file (Oracle 10g, AIX)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to read content from a datapump file [message #340594]

Wed, 13 August 2008 06:27

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!

Report message to a moderator

Re: How to read content from a datapump file [message #340611 is a reply to message #340594]

Wed, 13 August 2008 07:31

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

Report message to a moderator

Re: How to read content from a datapump file [message #340618 is a reply to message #340594]

Wed, 13 August 2008 07:55

Cowon_d3
Messages: 6
Registered: August 2008
Location: Norway

Junior Member

Thanks a lot. Exactely what i was looking for Smile

Report message to a moderator

Previous Topic:	DBMS_DATAPUMP
Next Topic:	How to load the flat files to the oracle database?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 10:23:08 CST 2024