RE: Collapse partitions in 9i - What all options do i have?
- From: "Hallas, John (EXP N-ARM)" <john.hallas@xxxxxxxx>
- To: vikram singh <vikramsingh120@xxxxxxxxx>
- Date: Wed, 25 Jul 2007 15:33:06 +0100
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:
