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?

vikram singh

2007-07-25

Replies:

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@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.
 
 

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