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_at_gmail.com] Sent: 25 July 2007 15:26
To: Hallas, John (EXP N-ARM)
Cc: freelists; oracle-l-request_at_freelists.org 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_at_lmco.com> 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.

--
http://www.freelists.org/webpage/oracle-l