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 Received on Tue Oct 31 2000 - 15:20:21 CST