Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
Oracle Database + Options
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Jan 6, 2010 9:42 AM by
NOLOGGING in alter table...split partition
Jan 6, 2010 9:42 AM
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')) into (partition EB_LOGS_082008 tablespace EBLAST_TABLE, partition EB_LOGS_012010 tablespace EBLAST_TABLE) parallel;
This content has been marked as final.
Show 0 replies