Thanks for the suggestion. I'll look into it and report back to the group.
-Original Message-
Sent: Thursday, February 28, 2002 2:14 PM
To: Multiple recipients of list ORACLE-L
Oracle9i provides on online data move facility that will allow you to
do this with a minimum of restrictions.
Ron:
Thanks for the suggestion. I have looked into this, and found that its very
slow for hash partitions. It works well for range partitions. But, with hash
parititions a row may move more than once (each time you add a partition,
the row may move) And since I want 8 hash partitions, this is
All:
The dbms_redefinition thing works. My test on a table that I have exclusive
access to it took 10 minutes to convert a non-partitioned table of 9.5
million rows into a has partitioned table with 8 partitions!
I have included the script I used.
Thanks to all that replied!
Caver
BEGIN
Kevin,
how about using the ALTER TABLE EXCHANGE command to move the info from
a non-partitioned to a partitioned table.
ROR mª¿ªm
[EMAIL PROTECTED] 02/28/02 11:28AM
Hello!
I am trying to figure out the best way to convert a non-partitioned
table
with approx 20 million rows into a
I haven't done any stress testing - but check out
DBMS_REDEFINITION
hth
connor
--- Toepke, Kevin M [EMAIL PROTECTED] wrote:
Hello!
I am trying to figure out the best way to convert a
non-partitioned table
with approx 20 million rows into a hash-partitioned
table. This should be
done