Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> oracle partitioning issue

oracle partitioning issue

From: <msreejith_at_yahoo.com>
Date: 19 May 2006 04:57:36 -0700
Message-ID: <1148039856.535675.308010@u72g2000cwu.googlegroups.com>


Hi,
We have a huge table in oracle (~10+ Gigs of data). This table is partitioned by, say, col1 currently.
But we need to have the table partitioned by col2, since most of the queries will involve col2.
So the issue is: what is the easiest way out to redefine the table partitions.

Presuming that an additional amount of space is available (which is close to the space that current table data occupies) would like to know what kind of effort is required to have all the existing data partitioned by the new column (COL2).

And what are the steps we need to undertake to achieve this transition. Do we need to copy the existing data (~10Gigs) to another temp table? Does it require export/import? All these take lot of time. Is there any easier way out?

regards,
srm Received on Fri May 19 2006 - 06:57:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US