RE: Range Partitioning ?'s

From: Leslie Tierstein <leslie.tierstein_at_visionchain.com>
Date: Tue, 24 May 2005 03:21:38 -0500 (EST)
Message-ID: <4AE2782C2093B34784E67971035A816006811919@ehost011-2.exch011.intermedia.net>

Suggest you look at ch 17 of DBA Guide, Managing Partitioned Tables and Indexes, and investigate using MERGE PARTITION and ALTER TABLE EXCHANGE PARTITION...=20
-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bryan Wells Sent: Friday, May 20, 2005 4:56 PM
To: Oracle-L
Subject: Range Partitioning ?'s

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.

store off tablespace/table/index ddl=20
export specific table=20
drop partition / tablespace=20
recreate tablespace / table w/o partitioning=20
import table data from step 2=20
recreate indexes=20
analyze tables=20
analyze indexes

--

Bryan S Wells - DBA Newbie
bunjibry_at_gmail.com

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Tue May 24 2005 - 04:24:35 CDT