Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: direct =y in export statement

Re: direct =y in export statement

From: Tom Pall <tom_at_cdproc.com>
Date: Tue, 31 Oct 2000 16:08:47 -0600
Message-Id: <10666.120750@fatcity.com>


Yup, exotic objects and column types.
----- Original Message -----
From: TheOracle DBA <theoracledba_at_lycos.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Tuesday, October 31, 2000 3:21 PM
Subject: Re: direct =y in export statement

> It will not export objects, LOBs, etc.
>
> Cheers,
>
> Earl
>
>
>
> On Tue, 31 Oct 2000 12:26:12
> Tom Pall wrote:
> >direct =y in export statementIt signifies that the export will be done directly from the data files directly to the dmp instead
> >of being dragged through the buffer cache. It also means you have to have the NLS parameters just so,
> >can't export more exotic objects or column types. Runs many times faster than direct=n.
> >
> >Import direct=n means all the above and a lot more. A lot more caution. When importing with direct=n,
> >indexes are rebuilt after the table is loaded. Constraints are checked after the tables are loaded. Very fast,
> >lower impact upon the box and the database, high risk for duplicate rows, constraints which cannot be enabled.
> >When you import with direct=y, you are declaring you don't need Oracle to do a lot of its usual checking for you.
> >
> >----- Original Message -----
> > From: Swapna_P
> > To: Multiple recipients of list ORACLE-L
> > Sent: Tuesday, October 31, 2000 1:20 PM
> > Subject: direct =y in export statement
> >
> >
> > what does this indicate?
> > what is its significance?
> >
> >
>
>
> Get FREE Email/Voicemail with 15MB at Lycos Communications at http://comm.lycos.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: TheOracle DBA
> INET: theoracledba_at_lycos.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Tue Oct 31 2000 - 16:08:47 CST

Original text of this message

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