| Moving Partitions between Tables of Same Structure [message #392706] |
Thu, 19 March 2009 00:34  |
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  |
 |
Michel Cadot
Messages: 68665
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
