Re: Range Partitioning ?'s
- From: Paul Drake <bdbafh@xxxxxxxxx>
- To: bunjibry@xxxxxxxxx
- Date: Fri, 20 May 2005 17:14:06 -0400
On 5/20/05, Bryan Wells <bunjibry@xxxxxxxxx> 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
> --
> Bryan S Wells - DBA Newbie
> bunjibry@xxxxxxxxx
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
