Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: using the export on open tables?
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
--
"Some days you're the pigeon, and some days you're the statue." Received on Fri Oct 08 1999 - 06:04:57 CDT