This discussion is archived
1 Reply Latest reply: Jan 14, 2010 3:51 AM by pparkko RSS

NOLOGGING in alter table...split partition

646430 Newbie
Currently Being Moderated
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;

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points