Partitioning on an existing table in Oracle 8.1.7

How to create a partition on an existing table (has 250 million records), in oracle 8.1.7? Also, the table has indexes and triggers associated with it.

I have one of the below method, don't know whether this will work !!!

1. ALTER TABLE TABLE_OLD_SOURCE RENAME TO TABLE_OLD_SOURCE_BACKUP; (  )
2. Create TABLE TABLE_NEW_TARGET with PARTITIONS based on letters
3. INSERT INTO TABLE_NEW_TARGET SELECT * FROM TABLE_OLD_SOURCE_BACKUP; COMMIT;
4. Create the indexes and triggers of TABLE_OLD_SOURCE, in TABLE_NEW_TARGET too
5. collect the stats of TABLE_NEW_TARGET

Doubts :

a. Don't know whether RENAME will work in this version?
b. In the above method, will step1 work, if triggers are there ?
c. Will the above method work?
d. Any other better or practically working methods? Please suggest. 

Thanks in Advance.

With Regards,
Raja. Received on Tue Jul 17 2012 - 07:17:52 CDT