Re: Export direct=Y|N

One caveat is that your 8.1.5 export can only be imported into another 8.1.5 database. You can't import this into 8.1.7 for instance IIRC.

Not sure how platforms and patch levels affect this.

Jared

On Thursday 22 May 2003 06:26, Wiegand, Kurt wrote:
> I ran across an export that was taking 9 1/2 to 10 hours to complete (the
> resulting dmp file was about 7GB compressed). I added DIRECT=Y and it now
> takes 3 1/2 hours. My question is: What are the reasons that someone would
> choose not to use DIRECT=Y? This is an 8.1.5.0.0 database running on a
> Solaris box; I would hate to have just removed a work around for some
> 8.1.5.0.0 bug! I have found comments in some scripts here, but they all
> seem to be in my handwriting!!
>
> Kurt kurt.wiegand_at_cwusa.com
>
>
> A ran a diff on the log files after the change. Here is the beginning
> (just what I expected).....
>
> 23c23,24
> < . about to export SYSTEM's tables via Conventional Path ...
> ---
>
> > . about to export SYSTEM's tables via Direct Path ...
> > EXP-00067: Table DEF$_AQCALL will be exported in conventional path.
>
> 24a26
>
> > EXP-00067: Table DEF$_AQERROR will be exported in conventional path.
>
> 29a32
>
> > EXP-00067: Table DEF$_LOB will be exported in conventional path.
>
> 33a37
>
> > EXP-00067: Table DEF$_TEMP$LOB will be exported in conventional path.
>
> 127c131
> < . about to export OUTLN's tables via Conventional Path ...
> ---
>
> > . about to export OUTLN's tables via Direct Path ...
>
> 130,136c134,140
> < . about to export DBSNMP's tables via Conventional Path ...
> < . about to export OPS$ORACLE's tables via Conventional Path ...
> < . about to export CW30_AUDITOR97's tables via Conventional Path ...
> < . about to export CW30_LAC_MANUAL's tables via Conventional Path ...
> < . about to export DISPUTES2's tables via Conventional Path ...
> < . about to export DISPUTES3's tables via Conventional Path ...
> < . about to export BANK's tables via Conventional Path ...
> ---
>
> > . about to export DBSNMP's tables via Direct Path ...
> > . about to export OPS$ORACLE's tables via Direct Path ...
> > . about to export CW30_AUDITOR97's tables via Direct Path ...
> > . about to export CW30_LAC_MANUAL's tables via Direct Path ...
> > . about to export DISPUTES2's tables via Direct Path ...
> > . about to export DISPUTES3's tables via Direct Path ...
> > . about to export BANK's tables via Direct Path ...

Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1"
Content-Transfer-Encoding: quoted-printable
Content-Description: 
----------------------------------------

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).