Exchange Partition dude [message #323984] |
Fri, 30 May 2008 03:56 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
mafc73
Messages: 38 Registered: November 2006
|
Member |
|
|
Hi,
I have a partitioned table(A) and I want to divide the partitions in two tables (A,A1). First I'm going to rename the table A to A1 (the majority of the partitions will be in A1), after that I'm going to create an identical partitioned table with name A and finally I'm going to use the exchange command but my question is that if it's possible exchange a partition among the partitioned tables directly or if I have to use an intermediate table?
Thanks
|
|
|
|
Re: Exchange Partition dude [message #324025 is a reply to message #323984] |
Fri, 30 May 2008 05:39 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
mafc73
Messages: 38 Registered: November 2006
|
Member |
|
|
The table A has 64000 partitions and we are near the top 655xx of version 10.1. We have only three days to reach the top and that the application fail. (We have planned in the near future upgrade the database to 10.2 but meanwhile we need an emergency solution)
Were there any other procedure best for the scenario proposed?
Thanks
|
|
|
Re: Exchange Partition dude [message #324031 is a reply to message #324025] |
Fri, 30 May 2008 06:06 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
S.Rajaram
Messages: 1027 Registered: October 2006 Location: United Kingdom
|
Senior Member |
|
|
Quote: | The table A has 64000 partitions
|
I am more curious to know why/what is your requirement to create 64000+ partitions in a single table. Till date I never heard or had an opportunity to see such a massive table / partitions.
Regards
Raj
|
|
|
|
Re: Exchange Partition dude [message #324058 is a reply to message #324025] |
Fri, 30 May 2008 08:24 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
mafc73 wrote on Fri, 30 May 2008 06:39 | The table A has 64000 partitions
|
How many gazillion rows does this table have? I am betting that partitions here are not helping at all.
|
|
|