Re: consistent = Y

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 5 Feb 1999 18:05:53 -0000
Message-ID: <918238014.9593.0.nnrp-09.9e984b29@news.demon.co.uk>

A __single__ table exported is ALWAYS read-consistent since exp is really doing little more than

select * from table
and dumping the contents.

consistent=Y
is equivalent to an SQL*Plus session doing:

set transaction read only
so that every select statement is read consistent to the time of the first select. i.e. all tables exported will be read-consistent to the point in time that the export started.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Doug Cowles wrote in message <36BB2C40.4B4C4BEB_at_bigfoot.com>...
>Some people think that a consistent = Y guarantees point of time for the
>entire
>database, thereby enforcing referenctial integrity. Others say it's
>only at the
>table level, and that any table is exported consistently, but not
>neccessarily how
>it connects to other tables. What's the real deal?
>
Received on Fri Feb 05 1999 - 12:05:53 CST