RE: Partitioning a live table

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

My misunderstanding this does work . . . but keep all you ddl for constraints and RI handy because dbms_redefinition looses them for you on the table being redef'ed

-----Original Message-----
From: Yen, Eric=20
Sent: Wednesday, May 19, 2004 5:12 PM
To: 'oracle-l_at_freelists.org'
Subject: RE: Partitioning a live table

The example that I have seen is this

START THE REDEF PROCESS=20 begin dbms_redefinition.start_redef_table ( 'TEST', 'TEST1', 'TEST2', null, dbms_redefinition.cons_use_rowid ); end;
SYNC IT EVERY NOW AND THEN=20 begin dbms_redefinition.sync_interim_table ( 'TEST', 'TEST1', 'TEST2' ); end;
FINISH THE SYNC=20 begin dbms_redefinition.finish_redef_table ( 'TEST', 'TEST1', 'TEST2' ); end;

Where =09
test is the schema =20
test1 is the non-partitioned table (orig_table)=20 test2 is the partitioned table (int_table).

Can the orig_table name and int_table name be the same?

Thanks for responding!

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Pete Sharman Sent: Wednesday, May 19, 2004 4:17 PM
To: oracle-l_at_freelists.org
Cc: Peter Ross Sharman
Subject: RE: Partitioning a live table

One would have to ask why DBMS_REDEFINITION doesn't meet your needs. Swapp=3D
ing a table to a partitioned table like this seems to be one of the few rea=3D
l uses of the package in a 24x7 environment.

=3D

Pete
=3D

"Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook
=3D

"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] =3D 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.

=3D

Can anyone provide some insight?

=3D

Regards, =3D

=3D

Eric Yen
http://www.sonypictures.com
AOL IM: metaldog888

Yahoo IM: metaldog_888

=3D

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
-----------------------------------------------------------------


----------------------------------------------------------------
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
-----------------------------------------------------------------


----------------------------------------------------------------
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 - 19:27:55 CDT