partition removal [message #9118] |
Mon, 20 October 2003 09:59 |
kshathrya
Messages: 29 Registered: October 2001
|
Junior Member |
|
|
i have a partitioned table, that has a whole bunch of constraints and indexes. I want to remove the partition, in other words I want to make it a non partitioned table, as we are moving to oracle standard edition from enterprise.
whats the best way to do this.
ks
|
|
|
Re: partition removal [message #9119 is a reply to message #9118] |
Mon, 20 October 2003 11:49 |
Thiru
Messages: 1089 Registered: May 2002
|
Senior Member |
|
|
One way is to employ CTAS ..like
Create table non-part as Select * from part_table@dblink;
Create Indexes later..
You can make this run faster by nologging,parallel..if you can.
|
|
|