make create table run faster?
Date: Tue, 28 Apr 2009 11:56:14 -0400
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?
GuangReceived on Tue Apr 28 2009 - 10:56:14 CDT