Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Non-partitioned table to Hash Partitioned table
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 with minimal down-time. This will be in an Oracle 9i environment done
at a time when only SELECTs are occuring on the table.
The best way I can figure is to create a second table and copy the data
over; create the indexes; and rename the tables.
I would appreciate any hints on what section of TFM to read.
Kevin Toepke
ktoepke_at_trilegiant.com
The information in this electronic mail message is Trilegiant Confidential
and may be legally privileged. It is intended solely for the addressee(s).
Access to this Internet electronic mail message by anyone else is
unauthorized. If you are not the intended recipient, any disclosure,
copying, distribution or action taken or omitted to be taken in reliance on
it is prohibited and may be unlawful.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: ktoepke_at_trilegiant.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing ListsReceived on Thu Feb 28 2002 - 10:28:25 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
![]() |
![]() |