Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Collapse partitions in 9i - What all options do i have?
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_at_gmail.com> wrote:
>
>
> What are the various ways i have to collapse partitions in a DB?
>
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Jul 22 2007 - 04:40:06 CDT
![]() |
![]() |