| Altering a Table Partition [message #284818] |
Sat, 01 December 2007 08:59  |
dba_giri
Messages: 26
Registered: July 2007
Location: Hyderabad
|
Junior Member |
|
|
Hi..,
I 've created a Table with out partitioning concept,
If I want to alter that table using the range/list partition.., how can I ?
can u please explain with syntax for this?
Thanks in Advance
Giri K.Y.
|
|
|
|
| Re: Altering a Table Partition [message #284822 is a reply to message #284818] |
Sat, 01 December 2007 10:18  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
1/ Always post your Oracle version (at elast 3 decimals)
2/ You can't do it directly, either
3a/ recreate the table
3b/ use dbms_redefinition
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
