Re: clarification on export's read consistency, please

Verna Legaspi wrote:
>
> Hello,
>
> Up to what "granuality" and point in time will my export file be consistent
> with my database? Let's say I'm exporting a schema with about 100 tables,
> and it takes, oh... about 1 hour. If in that hour, my users happen to
> access the DB and make updates, inserts, deletes, etc. on several tables -
> when can export guarantee "read consistency" on these tables?
>
> My understanding is that once export has "passed" a certain table, it's read
> consistency is guaranteed. Now, while export is "working" on this table,
> and users are also accessing this table, what will my export file contain?
> Will it contain the user's changes or not? Any in-betweens?
>
> Hope my question was clear. And thanks in advance for any replies...
>
> Verna

read consistent = n
Each table unloads data as it when the export of this particular table began

read consistent = ny
Each table unloads data as it when the export began

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"