Home » RDBMS Server » Server Utilities » Reading from Oracle Dump
Reading from Oracle Dump [message #177348] Wed, 14 June 2006 04:52 Go to next message
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
Re: Reading from Oracle Dump [message #177350 is a reply to message #177348] Wed, 14 June 2006 05:08 Go to previous messageGo to next message
orausern
Messages: 726
Registered: December 2005
Location: Hyderabad
Senior Member
by dump file u mean export dump file? in that case only import utility can read from it.
Re: Reading from Oracle Dump [message #177390 is a reply to message #177350] Wed, 14 June 2006 07:24 Go to previous messageGo to next message
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.
Re: Reading from Oracle Dump [message #177392 is a reply to message #177390] Wed, 14 June 2006 07:29 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10615
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.
Re: Reading from Oracle Dump [message #177395 is a reply to message #177392] Wed, 14 June 2006 07:37 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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.
Re: Reading from Oracle Dump [message #177406 is a reply to message #177402] Wed, 14 June 2006 08:02 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10615
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.
Re: Reading from Oracle Dump [message #177408 is a reply to message #177402] Wed, 14 June 2006 08:06 Go to previous messageGo to next message
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.
Re: Reading from Oracle Dump [message #177409 is a reply to message #177408] Wed, 14 June 2006 08:11 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10615
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.
Re: Reading from Oracle Dump [message #177411 is a reply to message #177406] Wed, 14 June 2006 08:20 Go to previous messageGo to next message
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?
Re: Reading from Oracle Dump [message #177414 is a reply to message #177411] Wed, 14 June 2006 08:25 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10615
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
Re: Reading from Oracle Dump [message #177489 is a reply to message #177414] Thu, 15 June 2006 00:11 Go to previous messageGo to next message
msgforsunil
Messages: 26
Registered: November 2005
Junior Member
Thanks to all for such a faster responses. Its amazing.
Re: Reading from Oracle Dump [message #180945 is a reply to message #177489] Wed, 05 July 2006 23:06 Go to previous messageGo to next message
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

Re: Reading from Oracle Dump [message #187963 is a reply to message #180945] Wed, 16 August 2006 09:27 Go to previous messageGo to next message
codeblue
Messages: 1
Registered: August 2006
Location: Victoria BC
Junior Member
Just tried the DBA utility in Toad and it works Great without the need of producing a text version of the dump file.
Re: Reading from Oracle Dump [message #473991 is a reply to message #187963] Wed, 01 September 2010 19:56 Go to previous messageGo to next message
rajesh4851
Messages: 85
Registered: January 2007
Member
dear friends,
I want to read the exported dump file.
Could you pls let me know the correct way?
What is DBA utility in TOAD? how to use of it?
Re: Reading from Oracle Dump [message #473992 is a reply to message #473991] Wed, 01 September 2010 19:59 Go to previous messageGo to next message
BlackSwan
Messages: 22513
Registered: January 2009
Senior Member
IMP SHOW=YES
Re: Reading from Oracle Dump [message #474012 is a reply to message #473991] Thu, 02 September 2010 01:00 Go to previous message
Michel Cadot
Messages: 58604
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do NOT use TOAD until you'll be an Oracle expert.
TOAD for a lazy beginner DbA is just the gates of hell.

Regards
Michel
Previous Topic: input variable in sqlloader ctl
Next Topic: IMP-00041: Warning: object created with compilation warnings
Goto Forum:
  


Current Time: Mon Jul 28 11:34:29 CDT 2014

Total time taken to generate the page: 0.10409 seconds