Home » RDBMS Server » Server Administration » Rename Table
Rename Table [message #352842] Thu, 09 October 2008 21:40 Go to next message
caprikar
Messages: 226
Registered: March 2007
Senior Member
Hi,
I'm trying to rename a table and am getting the error:

SQL> ALTER TABLE PADIM RENAME TO PADIM_TEMP;

ORA-26563: renaming this table is not allowed

I have oracle 10gR2 on HP-UX 11.23 and its a normal table

select OBJECT_NAME, OBJECT_TYPE from dba_objects
where object_name='PADIM';

OBJECT_NAME

--------------------------------------------------------------------------------
OBJECT_TYPE

--------------------------------------------------------------------------------
PADIM
TABLE

Thanks
Re: Rename Table [message #352844 is a reply to message #352842] Thu, 09 October 2008 21:53 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
May be there are some MV's built on it.
I would check the dependencies.
Re: Rename Table [message #352857 is a reply to message #352842] Thu, 09 October 2008 22:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-26563: renaming this table is not allowed
 *Cause: Attempt to rename a replicated table, an updatable materialized view
         table or the master table of a materialized view for which a
         materialized view log has beencreated.
 *Action: If desired, unregister the replicated table with
          dbms_repcat.drop_master_repobject, or use the recommended
          procedure to rename the master table of a materialized view.

Regards
Michel
Re: Rename Table [message #353564 is a reply to message #352842] Tue, 14 October 2008 03:27 Go to previous messageGo to next message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
Or you can create a table with the desired name and import all the data from the older table and delete the older table.
Re: Rename Table [message #354327 is a reply to message #353564] Fri, 17 October 2008 14:15 Go to previous message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
amul wrote on Tue, 14 October 2008 03:27
Or you can create a table with the desired name and import all the data from the older table and delete the older table.


it is important to understand the dependency of an object before drop/recreate Smile
Previous Topic: materialized views
Next Topic: archive destination
Goto Forum:
  


Current Time: Fri Dec 09 16:01:18 CST 2016

Total time taken to generate the page: 0.23372 seconds