Re: Integrity of dump file

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Tue, 28 Sep 2004 15:18:36 -0400
Message-ID: <pNidnWAPnYmyJMTcRVn-oQ@comcast.com>

"Arch" <Please.do.not_at_spam.me> wrote in message news:Gni6d.13079$gE.3773_at_newssvr31.news.prodigy.com...
| It seems to me...
| If I'm using Oracle exp (9.2.0.4) and data in a table is changed between
| the start and finish, the resulting dump file might contain inconsistent
| data and not be reliable.
| Is that a correct assumption? If so, is there any way to be certain
| that a dump file is good other than making the db inaccessible during
| the export?

could you be more specific in what you mean by 'dump' file, and what you mean by 'good'?

if you're doing hot backups, you're generally ok
if you're doing cold backups, the database should be shut down
if you're using exp, there is the CONSISTENT option to perform the export as

a read-only transaction

++ mcs Received on Tue Sep 28 2004 - 14:18:36 CDT