RE: Partitioning a live table

From: Pete Sharman <peter.sharman_at_oracle.com>
Date: Thu, 20 May 2004 10:29:04 +1000
Message-Id: <200405200029.i4K0T70h004221@rgmgw1.us.oracle.com>

No, but you don't want them to be.  TEST2 in your example is the newly defi=
ned partitioned table.  While the redefinition takes place, TEST1 continues=
 to be used.  At the end of the redefinition the tables are locked (the onl=
y time they are) while TEST1 is renamed TEST2 and TEST2 becomes the new TES=

T1.

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 10:12 AM
To: oracle-l_at_freelists.org
Subject: RE: Partitioning a live table

The example that I have seen is this

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

Where =3D09
test is the schema =3D20
test1 is the non-partitioned table (orig_table)=3D20 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=3D3D
ing a table to a partitioned table like this seems to be one of the few rea=3D3D
l uses of the package in a 24x7 environment.

=3D3D

Pete
=3D3D

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

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

=3D3D

Can anyone provide some insight?

=3D3D

Regards, =3D3D

=3D3D

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

Yahoo IM: metaldog_888

=3D3D

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


----------------------------------------------------------------
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:26:21 CDT