Home » RDBMS Server » Server Administration » Moving Partitions between Tables of Same Structure
Moving Partitions between Tables of Same Structure [message #392706] Thu, 19 March 2009 00:34 Go to next message
shankhan
Messages: 28
Registered: September 2008
Location: Pakistan
Junior Member
Dear Guys,

I have two partitioned tables that have the structure and non-overlaping partitions. I want to move partitions of one table to the other table. What is the best way to achieve this?

Regards
Re: Moving Partitions between Tables of Same Structure [message #392709 is a reply to message #392706] Thu, 19 March 2009 00:42 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>What is the best way to achieve this?
BEST?
Best based upon which metric?
Duration? I/O? what?
Re: Moving Partitions between Tables of Same Structure [message #392714 is a reply to message #392709] Thu, 19 March 2009 00:51 Go to previous messageGo to next message
shankhan
Messages: 28
Registered: September 2008
Location: Pakistan
Junior Member
Actually I am not a DBA but only a develper and have to perform this action and don't know the way to achieve this.
I would like to achieve this in minimum time.

Re: Moving Partitions between Tables of Same Structure [message #392725 is a reply to message #392706] Thu, 19 March 2009 01:39 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
- create an empty table with same structure of the partitioned tables
- create an empty partition in target table
- exchange table and source partition
- exchange table and target partition
- drop source empty partition
- drop work table

Regards
Michel
Previous Topic: arch extension
Next Topic: 10.2.0.4 Upgrade performance slow
Goto Forum:
  


Current Time: Sat Dec 10 08:54:03 CST 2016

Total time taken to generate the page: 0.09503 seconds