make create table run faster?
- From: "Guang Mei" <gmei@xxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- 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? Guang
- Follow-Ups:
- RE: make create table run faster?
- From: Bobak, Mark
- Re: make create table run faster?
- From: Daniel Fink
- RE: make create table run faster?
- From: Herring Dave - dherri
- RE: make create table run faster?
Other related posts:
- » make create table run faster? - Guang Mei
- » RE: make create table run faster? - Bobak, Mark
- » Re: make create table run faster? - Daniel Fink
- » RE: make create table run faster? - Bobak, Mark
- » Re: make create table run faster? - Guang Mei
- » RE: make create table run faster? - Mark W. Farnham
- » RE: make create table run faster? - Saibabu Devabhaktuni
- » RE: make create table run faster? - Herring Dave - dherri