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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Pete Sharman
Sent: Wednesday, May 19, 2004 4:17 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] =3D
On Behalf Of Yen, Eric
Sent: Thursday, 20 May 2004 7:43 AM
To: oracle-l@xxxxxxxxxxxxx
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


 =3D


Regards, =3D


 =3D


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

Yahoo IM:    metaldog_888

 =3D


 =3D


 =3D



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

Other related posts: