Range Partitioning ?'s

From: Bryan Wells <bunjibry_at_gmail.com>
Date: Fri, 20 May 2005 14:55:57 -0600
Message-ID: <b78d5a2005052013553118de18@mail.gmail.com>

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
export specific table
drop partition / tablespace
recreate tablespace / table w/o partitioning
import table data from step 2
recreate indexes
analyze tables
analyze indexes

--

Bryan S Wells - DBA Newbie
bunjibry_at_gmail.com

--

http://www.freelists.org/webpage/oracle-l Received on Fri May 20 2005 - 17:00:37 CDT