| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Partitioning a live table
One would have to ask why DBMS_REDEFINITION doesn't meet your needs. Swapp=
ing a table to a partitioned table like this seems to be one of the few rea=
l uses of the package in a 24x7 environment.
=
Pete
=
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
=
"Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] =
On Behalf Of Yen, Eric
Sent: Thursday, 20 May 2004 7:43 AM
To: oracle-l_at_freelists.org
Subject: Partitioning a live table
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
=
=
=
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- 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 - 18:14:39 CDT
 |
 |