Oracle-L: Re: Non-partitioned table to Hash Partitioned table

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Thu, 28 Feb 2002 10:43:44 -0800
Message-ID: <F001.0041B77F.20020228104344@fatcity.com>

Kevin,
how about using the ALTER TABLE EXCHANGE command to move the info from a non-partitioned to a partitioned table. ROR mª¿ªm

>>> ktoepke_at_trilegiant.com 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 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.

The sender believes that this E-mail and any attachments were free of any
virus, worm, Trojan horse, and/or malicious code when sent. This message and
its attachments could have been infected during transmission. By reading the
message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and
other defects. Trilegiant Corporation is not liable for any loss or damage
arising in any way from this message or its attachments.

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


--------------------------------------------------------------------


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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ron Rogers
  INET: RROGERS_at_galottery.org

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------


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

Received on Thu Feb 28 2002 - 12:43:44 CST