Partitioning a live table

From: Yen, Eric <EYen_at_sonypictures.com>
Date: Wed, 19 May 2004 14:42:55 -0700
Message-ID: <32EFAEA4102B7041842430B3B393857303302DDF@sl-mail2a.spde.net>

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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Wed May 19 2004 - 16:39:53 CDT