OraFAQ Forum: SQL & PL/SQL » Renaming a table

Home » SQL & PL/SQL » SQL & PL/SQL » Renaming a table (Oracle 11)

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

Renaming a table [message #654851]

Tue, 16 August 2016 03:38

saipradyumn
Messages: 419
Registered: October 2011
Location: Hyderabad

Senior Member

If we rename a table all the constrains,indexes,partitions of the original will copied to the newly created table also ?

Report message to a moderator

Re: Renaming a table [message #654855 is a reply to message #654851]

Tue, 16 August 2016 03:48

John Watson
Messages: 8930
Registered: January 2010
Location: Global Village

Senior Member

A "renamed" table is not a "newly created" table. Which is it?

Report message to a moderator

Re: Renaming a table [message #654875 is a reply to message #654855]

Tue, 16 August 2016 06:26

saipradyumn
Messages: 419
Registered: October 2011
Location: Hyderabad

Senior Member

My intention renamed table (not newly created )

Report message to a moderator

Re: Renaming a table [message #654878 is a reply to message #654875]

Tue, 16 August 2016 06:35

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Can't you just test it? It is really a simple task ...

Report message to a moderator

Re: Renaming a table [message #654881 is a reply to message #654878]

Tue, 16 August 2016 07:28

Bill B
Messages: 1971
Registered: December 2004

Senior Member

All I rename does is change the name of an object. All linked objects (constraints, indexes,...) are still linked to the original objects since they are linked using the object id# not the actual name.

Report message to a moderator

Re: Renaming a table [message #654952 is a reply to message #654881]

Wed, 17 August 2016 07:23

victoryhendry
Messages: 96
Registered: January 2007
Location: Bangalore

Member

nope. it wont change the constraints wont change to the renamed table.

Thanks,
Victory,Dpi-Oralce

[Updated on: Wed, 17 August 2016 07:23]

Report message to a moderator

Re: Renaming a table [message #654954 is a reply to message #654952]

Wed, 17 August 2016 07:28

Bill B
Messages: 1971
Registered: December 2004

Senior Member

Of course it does NOT rename all the constraints however they are still being applied against the renamed table.

Report message to a moderator

Previous Topic:	PL/SQL: ORA-00942: table or view does not exist
Next Topic:	previous data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 04:17:51 CDT 2024