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