Does anyone know of a technique to change a table into a range partitioned table in a 24 * 7 system? I have looked at dbms_redefinition package already and it does not fulfill my requirements. I need to be able to convert table into a range partition table along the column date. Keep the original table name and all the constraints and RI. Can anyone provide some insight? Regards, Eric Yen http://www.sonypictures.com AOL IM: metaldog888 Yahoo IM: metaldog_888 ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------