RE: Help Needed regarding partitioning

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Wed, 25 Jun 2003 06:47:46 -0700
Message-ID: <F001.005B9167.20030625061418@fatcity.com>

Jack, Munish
First, verify that you have licensed partitioning. Additional cost item. Second, learn about EXCHANGE PARTITION. This is a highly useful command that can be used for a multitude of uses. Create a partitioned table and then exchange your table into it. Extremely fast since it just involves dictionary manipulations. It can be used for other purposes like renaming columns, changing the owner of a table, etc.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] -----Original Message-----
Sent: Wednesday, June 25, 2003 6:15 AM
To: Multiple recipients of list ORACLE-L

Hi,

I'm currently looking into the same.

My idea is to create a new table with the partitions I need, insert the data from the old table, drop the old table and rename the new table to the old name.

This will invalidate a lot of stuff, which I still have to find out exactly what, so if somebody has a script to find all the dependencies already.....?

Anybody have a different/better idea, because the insert may take a long time?

Jack

-----Original Message-----
Sent: Wednesday, June 25, 2003 11:54 AM
To: Multiple recipients of list ORACLE-L

Hi Listers,

Please let me know whether I can convert an existing heavy table into a partitioned table and how? I need this to improve my query performance.

Thanks and Best Regards

Munish Bajaj

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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 Wed Jun 25 2003 - 08:47:46 CDT