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 Archived Forums
This discussion is archived
on Jan 14, 2010 11:51 AM by pparkko
NOLOGGING in alter table...split partition
Jan 6, 2010 3:43 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')) NOLOGGING 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 1 reply
Re: NOLOGGING in alter table...split partition
Jan 14, 2010 11: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!