| Oracle Partitioning [message #608568] |
Fri, 21 February 2014 02:34  |
s4.ora
Messages: 71
Registered: March 2010
|
Member |
|
|
Hi All,
I have a table with Partitions, and now I want to remove all the partition and make it a non partitioned table and want to retain the data as well, I have searched Google but could not find any solution, Kindly help.
|
|
|
|
| Re: Oracle Partitioning [message #608575 is a reply to message #608568] |
Fri, 21 February 2014 02:52  |
John Watson
Messages: 8931
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
|
You can merge the partitions, so that you have a table consisting of one partition. That will be, for functional purposes, the same as a non-partitioned table.
|
|
|
|
|
|
| Re: Oracle Partitioning [message #608585 is a reply to message #608581] |
Fri, 21 February 2014 03:22 |
 |
Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
And don't forget to have MAXVALUE as the limit of the last partition (if you use range partitioning) or DEFAULT value (if you use LIST partitioning).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
