Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle-l »

Re: Collapse partitions in 9i - What all options do i have?

David Sharples

2007-07-22

Replies:

create table xxx as select * from yyy; drop yyy, rename xxx to yyy and rebuild your indexes - with those tiny tables it wont take any time at all

On 22/07/07, vikram singh <vikramsingh120@gmail.com> wrote:
 
What are the various ways i have to collapse partitions in a DB?

©2008 dba.5341.com - Jax Systems, LLC, U.S.A.