1 Reply Latest reply: Jan 14, 2010 5:51 AM by pparkko RSS

    NOLOGGING in alter table...split partition

    646430
      Hi All,

      Please can any one tell me where should i add the NOLOGGING in the below statement, or any other means by which i can stop the redo being generated

      alter table EB_LOGS split partition EB_LOGS_082008 at (to_date('01-01-2010','DD-MM-YYYY')) NOLOGGING into (partition EB_LOGS_082008 tablespace EBLAST_TABLE, partition EB_LOGS_012010 tablespace EBLAST_TABLE) parallel;