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
OTN Speaker Bureau
Please enter a title.
You can not post a blank message. Please type your message and try again.
Oracle Database + Options
This discussion is archived
on Jan 6, 2010 3:42 PM by 646430
NOLOGGING in alter table...split partition
Jan 6, 2010 3:42 PM
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;
I have the same question
Show 0 Likes
This content has been marked as final.
Show 0 replies