Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: using the export on open tables?

Re: using the export on open tables?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Fri, 08 Oct 1999 19:04:57 +0800
Message-ID: <37FDCFD9.2D49@yahoo.com>


Joe D wrote:
>
> What kind of affect is there on a open/active table when running a export
> against the table? Does this affect writes on the table, if so how?
>
> Thanks for your help
>
> Joe

Nope...

Its the same way in that when you do "select * from table" it gets the consistent read of data even if people are updating it...

You can also specifiy the CONSISTENT parameter (cf: Server Utilities) which will give a consistent export across tables (handy for ensuring referential integrity)

HTH
--



Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Fri Oct 08 1999 - 06:04:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US