Re: How to stop a database growing in size on the disk
Posted by:
Rick James
Date: October 10, 2013 09:46PM
ALTER TABLE ... REORGANIZE PARTITION
would do similar stuff in a single step.
(Yes, you can reorganize a single partition into itself. Do not use OPTIMIZE PARTITION, there is a bug in it--it will OPTIMIZE all partitions and take a long time.)
Subject
Written By
Posted
Re: How to stop a database growing in size on the disk
October 10, 2013 09:46PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.