| 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
In unix,
export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
then do your export.
>>> Brad.Odland_at_qtiworld.com 05/22/03 09:47AM >>>
I was having some problems with character sets not five minutes ago
while
using DIRECT=Y I was getting EXP-00041 so I used conventional. The
Database
has a WE8ISO8859P1 and the export was wanting to be done in US7ASCII.
Rather
than take the time to figure that out I just set it a conventional for
now
and will tackle why these character sets are different later today....
DIRECT=Y precludes the use of interactive mode exp...sometimes I am
lazy
when I just want to quick dump a table before making some big table
fixes or
rebuilds I use interactive mode.
Metalink note:155477.1
Has a list of limitations with Direct. Good read actually...
Are you compress the export on the fly...by making a thread? That is
cool. I
have the command syntax around somewhere..it's not in my head right
now...HA!here it is right where I used it last in the very directory
I'm
in...
(hp/ux) - variations depending on platform...
autozip.sh filename user password tablename
mknod /tmp/temp_pipe p
compress < /tmp/temp_pipe > "$1".Z &
exp "$2"/"$3" file=/tmp/temp_pipe <exp parameters> table="$4"
rm /tmp/temp_pipe
Brad O.
-----Original Message-----
Sent: Thursday, May 22, 2003 8: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 ... ---
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Darrell Landrum INET: DLANDRUM_at_zalecorp.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 - 11:17:16 CDT
 |
 |