RE: Cloning 21 GB Table - Review Approach please

Will Arhive Redo Log be generated by the INSERT /*+ APPEND */ Command if = the Target Table has been PRE-Created with NOLOGGING?

Any possibility of giving Hint for NOLOGGING in the INSERT Command ?

-----Original Message-----
From: VIVEK_SHARMA=20
Sent: Thursday, March 10, 2005 3:31 PM
To: 'oracle-l_at_freelists.org'
Subject: Cloning 21 GB Table - Review Approach please

We are to clone a 32Million records table of approx 21GB in the same DB.
=A0

We are considering the following approach:-

MULTIPLE statements INSERT /*+ APPEND */ INTO <Target Table> SELECT ... = FROM <Source Table> WHERE Suitable Condition ..... to be executed.

Num of concurrent (parallel) executions to depend on the Machine config = (Num of CPUs & nature of Storage Box)

/*+ APPEND */ Hint causes a Block wise(NOT row-wise) Load into the = Target table provided NO indexes exist on it.

(Oracle 9.2 version much faster for such loads than Oracle 8i)
=A0

OPTIMIZATION PREPERATION=20
Suitable partitioning for the target table=20 Partitions to be Located in different Tablespaces Tablespaces to be LMTs
=A0

Existence of any suitable indexes on Source Table for faster Selection = of records therefrom.
=A0

Database Init.ora params to be optimized OS parameters to be optimized=20
=A0

--
http://www.freelists.org/webpage/oracle-l