RE: Help Needed regarding partitioning

From: Gogala, Mladen <MGogala_at_oxhp.com>
Date: Wed, 25 Jun 2003 08:51:06 -0700
Message-ID: <F001.005B919B.20030625061420@fatcity.com>

You first create an empty partitioned table with the same structure as the original table and then use "exchange partition" to
exchange partitions with the original table. That way, your original table
will end up having a single (empy)
partition and the new table will have a full partiton. Now, split the partitions
in the new table, rename the old one,
rebuild the indexes, recreate grants and presto, you're ready to go.

Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED]

  <FONT
  face=Tahoma>-----Original Message-----From: Munish Bajaj   [mailto:[EMAIL PROTECTED]Sent: Wednesday, June 25, 2003 5:54   AMTo: Multiple recipients of list ORACLE-LSubject: Help   Needed regarding partitioning
  Hi Listers,
  Please let me know whether I can convert an   existing heavy table into a partitioned table and how? I need this to improve   my query performance.
  Thanks and Best Regards
  Munish
Bajaj Received on Wed Jun 25 2003 - 10:51:06 CDT