Rick, These are the transactions:
This one does not create any logs (nothing was written into arch directory); insert /*+ parallel (egurev1.offr,16) */ into egurev1.offr nologging (select a.PRDCT_ID , a.OFFR_RSPNS_TYP_CDE , a.PRTY_TYP_NBR , a.PREFR_IND , a.OFFR_CNT , a.PROC_MTH_VAL , a.TRSFR_RSPNS_CDE , a.EXPCT_GRID_SCR_VAL, b.OFFR_CALL_KEY from ccsrep.offr a, egurev1.offr_call b where a.acct_nbr = b.acct_nbr and a.dt_nbr = b.dt_nbr and a.usr_id = b.usr_id ); This one created a few logs in the arch directory: insert /*+ parallel (egurev1.offr_Call,16) */ into egurev1.offr_Call nologging (sele ct /*+ parallel (b,16) */ ACCT_NBR , USR_ID , DT_NBR , OPERS_CNTR_CDE, DEPT_ID , CRD_TYP_NBR , OPT_CDE , IVR_CDE , IVR_FL_IND , IVR_PASS_IND , CALL_CNT , PROC_MTH_VAL, INBD_OUTBD_CDE , offr_call_key.nextval from ccsrep.offr_call b, dual) / When executing no indices were existing on the target tables. Gene --- [EMAIL PROTECTED] wrote: > > As long as you are doing INSERT INTO ... using CTAS > it can make use of > NOLOGGING according to Oracle. I do not know > why the single table does not use it. Perhaps > posting relevant portion of > insert stmt may provide some help __________________________________________________ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
