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>
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-lReceived on Tue Apr 28 2009 - 10:56:14 CDT