OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Rename Table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Rename Table [message #352842]

Thu, 09 October 2008 21:40

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

Report message to a moderator

Re: Rename Table [message #352844 is a reply to message #352842]

Thu, 09 October 2008 21:53

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

May be there are some MV's built on it.
I would check the dependencies.

Report message to a moderator

Re: Rename Table [message #352857 is a reply to message #352842]

Thu, 09 October 2008 22:59

Michel Cadot
Messages: 68666
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

Report message to a moderator

Re: Rename Table [message #353564 is a reply to message #352842]

Tue, 14 October 2008 03:27

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.

Report message to a moderator

Re: Rename Table [message #354327 is a reply to message #353564]

Fri, 17 October 2008 14:15

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

Report message to a moderator

Previous Topic:	materialized views
Next Topic:	archive destination

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jul 07 23:48:21 CDT 2024