Home » SQL & PL/SQL » SQL & PL/SQL » Change Max Partitionname (Oracle, 11G,Solaris)
Change Max Partitionname [message #597339] Thu, 03 October 2013 05:49 Go to next message
nagaraju.ch
Messages: 103
Registered: July 2007
Location: bangalore
Senior Member
Hi

I want to change the partition name for my existing max value partition. I tried searching in forums but couldn't get theinfo.

Can we do that?

For Example
I have partition PART_30001230, i want to change this to part_maxvalue

Report message to a moderator

Re: Change Max Partitionname [message #597340 is a reply to message #597339] Thu, 03 October 2013 05:56 Go to previous message
nagaraju.ch
Messages: 103
Registered: July 2007
Location: bangalore
Senior Member
got it, thanks

ALTER TABLE <tablename> RENAME PARTITION <old_partition>to <new_partition>

Report message to a moderator

Previous Topic: creating the materialized view for getting the hierarchy
Next Topic: error when using return along with ref cursor
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 17:51:36 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.