Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Which would be faster method of removing a partition?

656919Jan 30 2010 — edited Jan 31 2010
I have a table partitioned on a CREATE_DATE column, so daily partitions. I have a job that nightly trims off the 'old' partitions and was wondering which method would be faster:


1. ALTER TABLE FLOW_COMPLETION_RECORD_PART DROP PARTITION D2010019_FCR UPDATE GLOBAL INDEXES;

or

2.
ALTER TABLE FLOW_COMPLETION_RECORD_PART TRUNCATE PARTITION D2010019_FCR ;
ALTER TABLE FLOW_COMPLETION_RECORD_PART DROP PARTITION D2010019_FCR UPDATE GLOBAL INDEXES;


There are about 1.5 million records in a partition, all indexes are global. I am doing step 1 now and it takes much longer than I would like. Is there a way I can specify nologging or such on the 'DROP PARTITION' command?

Thanks,

M
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 28 2010
Added on Jan 30 2010
6 comments
1,058 views