OraFAQ Forum: Server Utilities » Reading from Oracle Dump

Home » RDBMS Server » Server Utilities » Reading from Oracle Dump

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

Reading from Oracle Dump [message #177348]

Wed, 14 June 2006 04:52

msgforsunil
Messages: 26
Registered: November 2005

Junior Member

Hi All,

Kindly let me know, is there is any way of reading from oracle dump file?

Please let me know more on this.

Thanks,
Sunil

Report message to a moderator

Re: Reading from Oracle Dump [message #177350 is a reply to message #177348]

Wed, 14 June 2006 05:08

orausern
Messages: 826
Registered: December 2005

Senior Member

by dump file u mean export dump file? in that case only import utility can read from it.

Report message to a moderator

Re: Reading from Oracle Dump [message #177390 is a reply to message #177350]

Wed, 14 June 2006 07:24

msgforsunil
Messages: 26
Registered: November 2005

Junior Member

I am not talking about export/import functionality. I would like to read from the dump.. like the table names, its structure and the records.

Report message to a moderator

Re: Reading from Oracle Dump [message #177392 is a reply to message #177390]

Wed, 14 June 2006 07:29

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>> I would like to read from the dump
What "DUMP" are you talking about here?
As NiravShah has already stated, by conventional Oracle wisdom, "DUMP FILE" means the files created by oracle export utility which can be read only by Oracle import utility. This dump file is oracle proprietory.

Report message to a moderator

Re: Reading from Oracle Dump [message #177395 is a reply to message #177392]

Wed, 14 June 2006 07:37

ebrian
Messages: 2794
Registered: April 2006

Senior Member

If you want to see the contents in a text format, you could IMP and use the parameter SHOW = Y. But as the others have indicated, the dump file itself is proprietary and you won't be able to just go into the file and edit the contents.

Sorry, forgot to mention, you should also use LOG = <filename.log> to save the contents to a file.

[Updated on: Wed, 14 June 2006 07:38]

Report message to a moderator

Re: Reading from Oracle Dump [message #177402 is a reply to message #177392]

Wed, 14 June 2006 07:56

msgforsunil
Messages: 26
Registered: November 2005

Junior Member

Fine, thanks. What do I have to do in case, if I have to confirm few things before importing the dump into the database? In case, if iam not sure as what is there as part of the dump.

Report message to a moderator

Re: Reading from Oracle Dump [message #177406 is a reply to message #177402]

Wed, 14 June 2006 08:02

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>> if I have to confirm few things
Few things what?
As stated by EBrian, presence of an object can be done using show=y log=somelogfile
Using these options nothing is actually imported. So it is safe.
For data, there is no other option except to import into a database and check.

Report message to a moderator

Re: Reading from Oracle Dump [message #177408 is a reply to message #177402]

Wed, 14 June 2006 08:06

msgforsunil
Messages: 26
Registered: November 2005

Junior Member

for eg. "strings <dmp file name> |grep "CREATE TABLE"|wc -l " would give the number of tables as part of the dump.

Report message to a moderator

Re: Reading from Oracle Dump [message #177409 is a reply to message #177408]

Wed, 14 June 2006 08:11

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

You may 'hack' through it.
But why? Use the show=y the output is a just a text file.

Report message to a moderator

Re: Reading from Oracle Dump [message #177411 is a reply to message #177406]

Wed, 14 June 2006 08:20

msgforsunil
Messages: 26
Registered: November 2005

Junior Member

With "show=y the output is a just a text file option", would I be seeing the output without acutally importing the dump into oracle? Is it like test mode?

Report message to a moderator

Re: Reading from Oracle Dump [message #177414 is a reply to message #177411]

Wed, 14 June 2006 08:25

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Stated before
>>Using these options nothing is actually imported. So it is safe
Yes.
imp user/password file=filename.dmp fromuser=x touser=y show=y log=somelogfile.log

the somelogfile.log will have all the DDL for all objects.
If you are looking only for tables/indexes, use Indexfile=somefile

Report message to a moderator

Re: Reading from Oracle Dump [message #177489 is a reply to message #177414]

Thu, 15 June 2006 00:11

msgforsunil
Messages: 26
Registered: November 2005

Junior Member

Thanks to all for such a faster responses. Its amazing.

Report message to a moderator

Re: Reading from Oracle Dump [message #180945 is a reply to message #177489]

Wed, 05 July 2006 23:06

JonBeer
Messages: 1
Registered: July 2006

Junior Member

The DBA utilities in TOAD has File Browser that allows you to view export files. Although I think this function is only available in a fully licensed copy of TOAD.

J

Report message to a moderator