OraFAQ Forum: Backup & Recovery » How to verify the validity of an Export dump

Home » RDBMS Server » Backup & Recovery » How to verify the validity of an Export dump

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

How to verify the validity of an Export dump [message #229767]

Tue, 10 April 2007 00:10

girishta
Messages: 30
Registered: December 2006

Member

Hi,
How to verify the validity of an Export dump. I am not having any logs.

Report message to a moderator

Re: How to verify the validity of an Export dump [message #229768 is a reply to message #229767]

Tue, 10 April 2007 00:14

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>How to verify the validity of an Export dump.
By successfully importing the file.

Report message to a moderator

Re: How to verify the validity of an Export dump [message #229775 is a reply to message #229768]

Tue, 10 April 2007 00:32

girishta
Messages: 30
Registered: December 2006

Member

What if dump file is very large ?

Will it through the error saying that cannot be imported ?

With the same dump i am able to import a particular table. I got it successfully. How can i know that all the tables are perfectly exported other than trying to import the whole dump?

Another question:

What may be the possible reasons for the "Export terminated successfully with warnings?

Report message to a moderator

Re: How to verify the validity of an Export dump [message #229777 is a reply to message #229775]

Tue, 10 April 2007 00:42

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

Senior Member

Hi,
That is why i also used LOG parameter with EXPORT command.
first you should also use LOG parameter with EXPORT command.

What if dump file is very large ?
--->

rows=n show=y

Will it through the error saying that cannot be imported ?

---Very hard to say it depand on error message.

With the same dump i am able to import a particular table. I got it successfully. How can i know that all the tables are perfectly exported other than trying to import the whole dump?
---YOu have to imported all tables.

Another question:

What may be the possible reasons for the "Export terminated successfully with warnings?

---Again depand on situation.

Regards
Taj

Report message to a moderator

Previous Topic:	Off site backup for Oracle 10g XE
Next Topic:	Import dmp in 10g express

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 14 06:22:27 CDT 2024