Home » RDBMS Server » Server Administration » Rename a partitioned table
Rename a partitioned table [message #225755] Wed, 21 March 2007 05:13 Go to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Hi i want to rename a table that has partitions.

alter table
testora.oldtablename
rename to
testora.newtablename;

ORA-14048: a partition maintenance operation may not be combined with other operations

Any workaround for this ?
Re: Rename a partitioned table [message #225762 is a reply to message #225755] Wed, 21 March 2007 05:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You must be give the owner name in the rename clause:
SQL> create table t (id integer) partition by range (id) 
  2  (partition p1 values less than (1000), partition p2 values less than (maxvalue));

Table created.

SQL> alter table michel.t rename to michel.t2;
alter table michel.t rename to michel.t2
                                     *
ERROR at line 1:
ORA-14047: ALTER TABLE|INDEX RENAME may not be combined with other operations

SQL> alter table michel.t rename to t2;

Table altered.

Regards
Michel
icon12.gif  Re: Rename a partitioned table [message #520284 is a reply to message #225762] Sat, 20 August 2011 07:43 Go to previous message
bijunator
Messages: 1
Registered: March 2011
Location: Kochi
Junior Member
love u michael....u r an angel...
Previous Topic: NONASM TO ASM
Next Topic: System user login issue
Goto Forum:
  


Current Time: Sun Dec 04 06:10:21 CST 2016

Total time taken to generate the page: 0.25439 seconds