I figured it out. I have some columns set as unused which I guess forces a conventional export. ----- Original Message ----- From: "Michael McMullen" <ganstadba@xxxxxxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> 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@xxxxxxxxxxx > > > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------