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: Why export has conventional path?

Re: Why export has conventional path?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/04/09
Message-ID: <955311603.3979.0.pluto.d4ee154e@news.demon.nl>#1/1

There seems to be a problem with LOBs.
If you don't have LOBs your approach should be safe, given the conditions below.

Hth,

Sybrand Bakker, Oracle DBA

"Alan" <alan_psb_at_yahoo.com> wrote in message news:38F04BAE.85A4A844_at_yahoo.com...
>
> Sybrand,
>
> If I am sure that
>
> i) nobody currently in the database
> ii) no characterset conversions needed
>
> Is it safe to use direct mode export? This is because I need to do
 export on
> everyday and the time is tight (also with large data files). We don't want
 to
> use incremental export also.
>
> Thanks.
> Alan
>
> Sybrand Bakker wrote:
>
> > The direct export mode reads directly from the database, it doesn't
 issue
> > ordinary selects.
> > Hence, it doesn't use the normal read consistency model. I'm not going
 to
> > bet how many administrators run a direct export on a database with other
> > users connected! Actually, the only way to get a correct full database
> > export is to kick everyone out and make sure the database is in
 restricted
> > session.
> > The risk of running an export in direct mode is getting an inconsistent
> > export, if you don't kick everyone out. It is the same as creating a
 backup,
> > storing the tape in the same room as the server, and never test the
 recovery
> > scenario. (Don't think this doesn't happen, it does)
> > The second hence is: the export will by design get the characterset of
 the
> > database, characterset conversions are impossible.
> > You could argue you can always conduct the conversion on import (as
 there is
> > no direct import), however I have a feeling such conversions are
 definitely
> > faster upon export.
> >
> > Hth,
> >
> > Sybrand Bakker, Oracle DBA
> >
> > "Alan" <alan_psb_at_yahoo.com> wrote in message
> > news:38EEBFB5.41EBE0CF_at_yahoo.com...
> > > Hello all,
> > >
> > > I have a simple export question.
> > >
> > > I know that using export by direct path mode is faster than using
> > > the conventional path. I want to ask, why export not use the direct
 mode
> > > as the default mode (or even delete the conventional mode)? Is there
 any
> > > reason why export still has the converntional mode? What is the risk
 of
> > > using direct mode during export?
> > >
> > > Thanks,
> > > Alan
> > >
>
Received on Sun Apr 09 2000 - 00:00:00 CDT

Original text of this message

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