Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: using the export on open tables?
Thank you, and it does help.
Joe
joed_at_icoms.com
"Wheather you think you can
or you can't, you're right!"
Henry Ford
Connor McDonald <connor_mcdonald_at_yahoo.com> wrote in message
news:37FDCFD9.2D49_at_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 - 13:02:54 CDT