Remove Partition - Retain Data

[spicysudhi]

Hi,

How to remove partition on a table? I want to retain the data and completely remove the partitionning.

drop partition option removes the data as well. the end result i want is a table without partitions.

regards,
Sudhi

 

[LKBrwnDBA]

You will need to re-create the table without partitioning.






----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[Dagon]

Create an empty table matching the partition definition and exchange the table with the partition (alter table...exchange partition with table). The data has now been saved to your new table and you can drop the empty partition.

 

[spicysudhi]

Hi,

i exported the table data using EXP.
Create the table with NO partitioning.
imported data using IMP with Ignore=Y

After import the table again has partitions.

-------
Is the only way is to rename the object to something, create the table without partition and use Select insert statement?

regards,
Sudhi

 

[spicysudhi]

Ignore me. i was wrong. export, import works well.

thanks.
Sudhi