Drop Partitioning
- From: Bryan Wells <bunjibry@xxxxxxxxx>
- To: Oracle-L <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 3 Aug 2005 03:56:54 -0600
We have a test box that we want to remove partitioning from. does anyone
have the steps to retain table data while dropping the date range
partitioning. My first thought was the following. please correct me where I
go astray:
1. export the table data
2. create similar table in the same tablespace with the appropriate
constraints/indexes
3. insert into <new> as select * from <old>
4. alter table <old> drop partition
5. drop table <old> cascade
6. alter table <new> rename to <old>
Thank you in advance for your help and expertise...
Other related posts:
