Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Export with direct=y
On Tue, 27 Jun 2000 20:26:10 GMT, Ethan Post <epost1_at_my-deja.com> wrote:
>
>On another note, if I'm exporting an entire schema and consistent=y
>then do I get consistancy cross the entire schema assuming it's on a
>single tablespace or am I only getting a read consistent view of each
>object in the schema at the time that particular object exporting?
>
Ethan, you cannot have a SELECT statement read inconsistent data in ORACLE. If another transaction comes in, updates and commits, WHILE your SELECT is retrieving data, the data retrieved will be as at the time the SELECT started, ie, consistent. This is a default inbuilt into ORACLE (unless 8i has changed this...).
So if an export is using SELECT (which means it's not DIRECT=Y), then each table is consistent as at the time the export started to SELECT it.
CONSISTENT=Y is for the entire export set, not per table.
HTH
Cheers
Nuno Souto
nsouto_at_nsw.bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html
Received on Wed Jun 28 2000 - 00:00:00 CDT