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