| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Export direct=Y|N
We ran into an issue with partitioned tablespaces and different types of
indexing. I don't remember exactly (too many dead brain cells), however, it
was within 8.1.7.x.x and repaired in 9i (go figure).
Thank You
Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email: Stephen.Karniotis_at_Compuware.com
Web: www.compuware.com
-----Original Message-----
Sent: Thursday, May 22, 2003 9:27 AM
To: Multiple recipients of list ORACLE-L
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 ...---
The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Karniotis, Stephen INET: Stephen_Karniotis_at_compuware.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).Received on Thu May 22 2003 - 10:51:56 CDT
 |
 |