I figured it out. I have some columns set as unused which I guess forces a
conventional export.
----- Original Message -----
From: "Michael McMullen" <ganstadba_at_hotmail.com>
To: <oracle-l_at_freelists.org>
Sent: Wednesday, April 14, 2004 8:30 AM
Subject: why conventional not direct
> Oracle 9.2
> I have two tables voice.line_dup, voice.mike_test. mike_test was created
> using the scripts from voice.line_dup with the same constraints enabled.
I
> then inserted all of the data from line_dup into mike_test. Both tables
are
> in the same tablespace. I use the same batch file for both tables
> userid=xxx/xxxx direct=y indexes=y constraints=y grants=y compress=n
> statistics=none tables=voice.line_dup
> only the table name changes. and the same kornscript to export.
> When I use voice.line_dup it will only export in conventional mode, when
I
> do mike_test it uses direct mode.
>
> Any ideas
> thanks
> mike
> > ganstadba_at_hotmail.com
> >
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Wed Apr 14 2004 - 07:42:52 CDT
