Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Export with direct=y
While I'm sure you are correct on this issue as it does seem to make sense, when I run a direct=y consistent=y export no errors are produced. These options ran in conjunction should produce an error. Also looking in the Utilites manual I had to dig pretty hard to find that buffer is inconsistent with direct=y and have not found anything pertaining to the consistent parameter being incompatible with direct=y. Point being the docs could be a bit clearer on this.
On another note, if I'm exporting an entire schema and consistent=y then do I get consistancy cross the entire schema assuming it's on a single tablespace or am I only getting a read consistent view of each object in the schema at the time that particular object exporting?
In article <962132900.13044.1.pluto.d4ee154e_at_news.demon.nl>,
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> consistent=y is incompatible with direct=y, AFAIK.
> Also the buffer parameter is incompatible with direct=y
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> "Ethan Post" <epost1_at_my-deja.com> wrote in message
> news:8jaq8n$m0k$1_at_nnrp1.deja.com...
> > Even when consistent=y?
> >
> > In article <962127329.9201.1.pluto.d4ee154e_at_news.demon.nl>,
> > "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> > > Export direct=n is issuing ordinary selects. *normal* read
consistency rules
> > > apply
> > > export direct=y directly reads from database files, bypassing the
sql
layer,
> > > not guaranteeing any consistency.
> > >
> > > Hth,
> > >
> > > Sybrand Bakker, Oracle DBA
> > >
> > > "Juan Álvarez" <jalvarez_at_edisa.es> wrote in message
> > > news:8jamls$3ipq42_at_SGI3651ef0.iddeo.es...
> > > > Please, can anyone tell me what's the difference
> > > > between export with direct=y and direct=n
> > > >
> > > > export with direct=y option is twice faster than direct=n
> > > >
> > > > thanks,,
> > > > Daniel Paz
> > > >
> > > >
> > > >
> > >
> > >
> >
> > --
> > http://www.freetechnicaltraining.com/home/ethan
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
-- http://www.freetechnicaltraining.com/home/ethan Sent via Deja.com http://www.deja.com/ Before you buy.Received on Tue Jun 27 2000 - 00:00:00 CDT