Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> oracle partitioning issue
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