Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Range Partitioning ?'s
On 5/20/05, Bryan Wells <bunjibry_at_gmail.com> wrote:
> Related to my thread earlier this week. I have a range partitioned table
> that i want to drop partitioning on. can someone validate the following
> steps im taking or refer me to a good doc? im going to grab DOCID
> 166652.1from Metalink to start.
> 1. store off tablespace/table/index ddl
> 2. export specific table
> 3. drop partition / tablespace
> 4. recreate tablespace / table w/o partitioning
> 5. import table data from step 2
> 6. recreate indexes
> 7. analyze tables
> 8. analyze indexes
>=20 >=20
Brian,
There are other options besides moving the data out of the database. If you have the space, I would not use exp/imp.
search for the dbms_redefinition package (EE required). One could also rename/create table as select off of the old table and rebuild the indexes/constraints afterwards.
Paul
--=20
#/etc/init.d/init.cssd stop
# f=3Dma, divide by 1, convert to moles.
-- http://www.freelists.org/webpage/oracle-lReceived on Fri May 20 2005 - 17:18:57 CDT
![]() |
![]() |