Home » RDBMS Server » Server Administration » Altering a Table Partition
Altering a Table Partition [message #284818] Sat, 01 December 2007 08:59 Go to next message
Messages: 26
Registered: July 2007
Location: Hyderabad
Junior Member
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 Go to previous message
Michel Cadot
Messages: 63935
Registered: March 2007
Location: Nanterre, France, http://...
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

Previous Topic: Extent Allocation
Next Topic: Sys, Sysdba, user roles and passwords
Goto Forum:

Current Time: Thu Oct 27 12:10:32 CDT 2016

Total time taken to generate the page: 0.21241 seconds