OraFAQ Forum: Server Utilities » Contents of the dump file

Home » RDBMS Server » Server Utilities » Contents of the dump file

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

Contents of the dump file [message #303670]

Sat, 01 March 2008 21:20

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

Report message to a moderator

Re: Contents of the dump file [message #303672 is a reply to message #303670]

Sat, 01 March 2008 22:16

BlackSwan
Messages: 26766
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

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

Report message to a moderator

Re: Contents of the dump file [message #303675 is a reply to message #303674]

Sat, 01 March 2008 22:58

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

Report message to a moderator

Re: Contents of the dump file [message #303677 is a reply to message #303675]

Sat, 01 March 2008 23:04

durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere

Senior Member

Tried and it worked fine..

- das

Report message to a moderator

Re: Contents of the dump file [message #303802 is a reply to message #303670]

Sun, 02 March 2008 22:39

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).

Report message to a moderator

Re: Contents of the dump file [message #304103 is a reply to message #303802]

Tue, 04 March 2008 01:09

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Yes, Your right i didn't notice.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 17 03:10:48 CDT 2024