Moving Partitions between Tables of Same Structure [message #392706] |
Thu, 19 March 2009 00:34 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #392725 is a reply to message #392706] |
Thu, 19 March 2009 01:39 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 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
|
|
|