Home » RDBMS Server » Server Utilities » Contents of the dump file
Contents of the dump file [message #303670] Sat, 01 March 2008 21:20 Go to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Hi,

I have a dump from Oracle 8i. I trying to view it with the following command in 9i

imp advant@mse@dbase3 fromuser=mse touser=advant full=n show=y file=d:\d.dmp

the problem is I am just able to see the last part of the file as it is very big. I cannot do SPOOL as I am on the command prompt.

Any suggestions to view all the contents

- Das
Re: Contents of the dump file [message #303672 is a reply to message #303670] Sat, 01 March 2008 22:16 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>imp advant@mse@dbase3 fromuser=mse touser=advant full=n show=y file=d:\d.dmp

Below is untested but "should" work

imp advant@mse@dbase3 fromuser=mse touser=advant full=n show=y file=d:\d.dmp > capture.log

[Updated on: Sat, 01 March 2008 22:16] by Moderator

Report message to a moderator

Re: Contents of the dump file [message #303674 is a reply to message #303672] Sat, 01 March 2008 22:44 Go to previous messageGo to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Hi,

I did try it out but no contents are being copied...only file is being created

Any other possibility

- Das
Re: Contents of the dump file [message #303675 is a reply to message #303674] Sat, 01 March 2008 22:58 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Did you try with "LOG" parameter something like
"imp username/pwd@tns_entry file=os-path.dmp LOG=OS-PATH.TXT fromusr=xxx touser=yyy SHOW=y
Re: Contents of the dump file [message #303677 is a reply to message #303675] Sat, 01 March 2008 23:04 Go to previous messageGo to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Tried and it worked fine..

- das
Re: Contents of the dump file [message #303802 is a reply to message #303670] Sun, 02 March 2008 22:39 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Log shows import log and according your heading , to see contents of dump file use indexfile=file_name( just tables+indexes).
Re: Contents of the dump file [message #304103 is a reply to message #303802] Tue, 04 March 2008 01:09 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Yes, Your right i didn't notice.

Previous Topic: Import only data
Next Topic: sqlldr -direct path loading
Goto Forum:
  


Current Time: Sat Dec 03 13:41:22 CST 2016

Total time taken to generate the page: 0.10491 seconds