Is there a reason you are not creating a Global Temporary Table? And then populating with an INSERT SELECT? GTTs can save time/resource when properly used.
You also need to look at the SELECT to see if that is the time consumer.Also be aware that CTAS in 10g may provide incorrect results due to a bug with the hash group by operation. (Or is it CTAS is correct and the SELECT by itself is wrong?...either way you need to be aware of it!)
Regards, Daniel Fink -- Daniel Fink OptimalDBA.com - Oracle Performance, Diagnosis, Data Recovery and Training OptimalDBA http://www.optimaldba.com Oracle Blog http://optimaldba.blogspot.com Lost Data? http://www.ora600.be/ Guang Mei wrote:
Oracle 10g in a NONARCHIVE mode. I need to create some temp tables during some process. These temp tables will not be updated. I am doing something like this now: CREATE TABLE TMP_TABLE123 PCTFREE 0 parallel 3 nologging as select ... from <some_base_tables> Is there any other oracle parameters that I could use to make this step faster? Guang
-- Daniel Fink OptimalDBA.com - Oracle Performance, Diagnosis, Data Recovery and Training OptimalDBA http://www.optimaldba.com Oracle Blog http://optimaldba.blogspot.com Lost Data? http://www.ora600.be/
