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

You have at least 3 options now that are all feasible
 
You just need to work which is the quickest, least risk, least
complexity option  - take your pick of the one that suits your
requirements best.
 
Then test the solution before implementation (and test again if
necessary)
 
I think export and table rename is the easiest myself but not
necessarily the quickest. Don't forget to make a note of who has privs
on the table and what indexes and constraints exist currently

________________________________

From: vikram singh [mailto:vikramsingh120@xxxxxxxxx] 
Sent: 25 July 2007 15:26
To: Hallas, John (EXP N-ARM)
Cc: freelists; oracle-l-request@xxxxxxxxxxxxx
Subject: Re: Collapse partitions in 9i - What all options do i have?


Hi all,
 
Can i not transfer the data of the partitioned tables into a flat file
and use SQL*Loader to load back the data into non-partitioned tables?
Considering the amount of data that is involved, do you think this is a
feasible option? 
 
Regards,
Vikram.


On 7/24/07, Hallas, John (EXP N-ARM) <john.hallas@xxxxxxxx> wrote: 

        
        "Tried checking if Export/Import will help but i dont think this
will" 
         
        Wondered about this so tested (using 10g not 9i) and create
table compact as select * from partitioned_table definitely collapses
partitions. 
        No 9i to test it on.
         
         

________________________________

        . The data so far i have gathered is this: 
        
         
        1) Online Redefinition is possible - But we do not have Primary
keys - Can we do with ROWIDs? If yes, how?
        2) ALTER TABLE EXCHANGE PARTITION can be feasible - But i am not
much aware of this option?
        3) Tried checking if Export/Import will help but i dont think
this will.

Other related posts: