Not sure, but this will work as well;

create table tab1 as select * from tab2 where 1=2;
insert /*+ append */ into tab2 select * from tab1;

HWH.

-----Original Message-----
From: VIVEK_SHARMA [mailto:[Email Address Removed] Tuesday, July 31, 2001 4:24 AM
To: LazyDBA.com Discussion
Subject: CTAS with the DIRECT LOAD Option



Can somebody please Tell the COMMAND Syntax for CREATE TABLE AS SELECT *
FROM ANOTHER TABLE with the Direct LOAD Option ?

Seem to have Seen it Before on the List .





--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page