Home » RDBMS Server » Server Administration » Exchange Partition dude (Oracle 10gR1)
Exchange Partition dude [message #323984] Fri, 30 May 2008 03:56 Go to next message
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 #323991 is a reply to message #323984] Fri, 30 May 2008 04:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to use an intermediate table.

Regards
Michel
Re: Exchange Partition dude [message #324025 is a reply to message #323984] Fri, 30 May 2008 05:39 Go to previous messageGo to next message
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 messageGo to next message
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 #324033 is a reply to message #324025] Fri, 30 May 2008 06:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Were there any other procedure best for the scenario proposed?

You propose a scenario to move partitions across partitioned table, there is only one way to do it: via an intermediate table.

Regards
Michel
Re: Exchange Partition dude [message #324058 is a reply to message #324025] Fri, 30 May 2008 08:24 Go to previous message
joy_division
Messages: 4644
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.
Previous Topic: DB error
Next Topic: AS
Goto Forum:
  


Current Time: Sat Dec 10 14:54:05 CST 2016

Total time taken to generate the page: 0.07264 seconds