Range Partitioning ?'s
- From: Bryan Wells <bunjibry@xxxxxxxxx>
- To: Oracle-L <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 20 May 2005 14:55:57 -0600
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
--
Bryan S Wells - DBA Newbie
bunjibry@xxxxxxxxx
--
//www.freelists.org/webpage/oracle-l
Other related posts:
