make create table run faster?

From: Guang Mei <gmei_at_prospectiv.com>
Date: Tue, 28 Apr 2009 11:56:14 -0400
Message-ID: <6A2DE7F994424250B3DE4F43985CBA44_at_gmei>


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

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Apr 28 2009 - 10:56:14 CDT

Original text of this message