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 Archived Forums
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Jan 14, 2010 5:51 AM by
NOLOGGING in alter table...split partition
Jan 6, 2010 9:43 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')) NOLOGGING into (partition EB_LOGS_082008 tablespace EBLAST_TABLE, partition EB_LOGS_012010 tablespace EBLAST_TABLE) parallel;
This content has been marked as final.
Show 1 reply
Re: NOLOGGING in alter table...split partition
Jan 14, 2010 5:51 AM
in response to
you must do it beforehand:
ALTER TABLE EB_LOGS NOLOGGING;
After that you can run:
alter table EB_LOGS split partition ...
Just be sure that you know what you are doing with nologging!