| 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
A limitation that is removed in 10g. Upgra= de, upgrade! :)
Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's much harder th= an 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:31 AM
To: oracle-l_at_freelists.org
Subject: RE: Partitioning a live table
My misunderstanding this does work . . . but kee= p 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=3D20
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
dbms_redefinition.start_redef= _table (
'TEST= ', 'TEST= 1', 'TEST= 2', null,=
dbms_redefinition.cons_use_rowid
);
end;
dbms_redefinition.sync_interim_table (
'TEST= ', 'TEST= 1', 'TEST= 2' );
end;
dbms_redefinition.finish_redef_table (
'TEST= ', 'TEST= 1', 'TEST= 2' );
end;
Where =3D09
test is the schema =3D20=
test1 is the non-partitioned table (orig_table)=3D= 20
test2 is the partitioned table (int_table).
Can the orig_table name and int_table name be th= e 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 does= n't meet your needs.
Swapp=3D3D
ing a table to a partitioned table like this see= ms 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 th= an 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 tabl= e into a range
partitioned table in a 24 * 7 system?
I have looked at dbms_redefinition package alrea= dy 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 an= d all the constraints
and RI.
=3D3D
Can anyone provide some insight?
=3D3D
=3D3D
Regards, =3D3D
=3D3D
Eric Yen
AOL IM: metaldog88= 8
Yahoo IM: metaldog_888
=3D3D
=3D3D
=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 - 20:34:11 CDT
 |
 |