RE: Help Needed regarding partitioning

[Gogala, Mladen]

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] -----Original Message----- From: Munish Bajaj [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 5:54 AM To: Multiple recipients of list ORACLE-L Subject: 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