Home » RDBMS Server » Server Utilities » Can we validate the exported DMP file? (merged)
Can we validate the exported DMP file? (merged) [message #221492] Tue, 27 February 2007 03:12 Go to next message
deepakc
Messages: 10
Registered: February 2007
Location: India
Junior Member
Is there any possible way to check whether the exported *.dmp file is valid and it will work fine or not, without importing it ???

Thnk u.,
Deepak.C
can we validate the exported dump(*.dmp) file ? [message #221499 is a reply to message #221492] Tue, 27 February 2007 03:43 Go to previous messageGo to next message
deepakc
Messages: 10
Registered: February 2007
Location: India
Junior Member
In Oracle9i, Is there any possiblity to validate or check the exported dump(*.dmp) file,to assure whether it will work fine or not without importing it ????

Thnk u.,
Deepak.C
Re: Can we validate the exported *.dmp [message #221502 is a reply to message #221492] Tue, 27 February 2007 04:00 Go to previous messageGo to next message
KenJ
Messages: 69
Registered: July 2006
Location: London
Member
Try imp with SHOW=Y. The block headers will have to be read and this should throw errors if there is corruption. Can anyone corroborate this?
Ken.
Re: Can we validate the exported *.dmp [message #221509 is a reply to message #221502] Tue, 27 February 2007 04:29 Go to previous messageGo to next message
deepakc
Messages: 10
Registered: February 2007
Location: India
Junior Member
Thank u very much ken.,

But can i use it through my java coding to find out the errors in the dump or the corrupted heades ???

Thnk u.,
Deepak.C

[Updated on: Tue, 27 February 2007 04:29]

Report message to a moderator

Re: can we validate the exported dump(*.dmp) file ? [message #221513 is a reply to message #221499] Tue, 27 February 2007 04:33 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
export/import is a logical process.
You can do a dummy import with show=y to see the contents of import. But you cannot check the data.
Re: can we validate the exported dump(*.dmp) file ? [message #221516 is a reply to message #221513] Tue, 27 February 2007 04:39 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
And DO NOT CROSSPOST
Re: can we validate the exported dump(*.dmp) file ? [message #221713 is a reply to message #221516] Wed, 28 February 2007 02:54 Go to previous message
deepakc
Messages: 10
Registered: February 2007
Location: India
Junior Member
Ok., Thnk u.

Deepak.C
Previous Topic: can data pump only export/import views also.
Next Topic: Date checking
Goto Forum:
  


Current Time: Wed Dec 25 20:22:06 CST 2024