Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Drop Partitioning

Drop Partitioning

From: Bryan Wells <bunjibry_at_gmail.com>
Date: Wed, 3 Aug 2005 03:56:54 -0600
Message-ID: <b78d5a2005080302567b99dbb7@mail.gmail.com>


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

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 03 2005 - 04:58:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US