RE: Help Needed regarding partitioning

[Jack van Zanen]

Hi,   I'm currently looking into the same.   My idea is to create a new table with the partitions I need, insert the data from the old table, drop the old table and rename the new table to the old name.   This will invalidate a lot of stuff, which I still have to find out exactly what, so if somebody has a script to find all the dependencies already.....?   Anybody have a different/better idea, because the insert may take a long time?       Jack -----Original Message----- From: Munish Bajaj [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 11: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