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: Joe D <joed_at_icoms.com>
Date: Fri, 8 Oct 1999 14:02:54 -0400
Message-ID: <37fe31c2@News.Destek.net>


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

Original text of this message

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