Home » SQL & PL/SQL » SQL & PL/SQL » Renaming a table (Oracle 11)
Renaming a table [message #654851] Tue, 16 August 2016 03:38 Go to next message
saipradyumn
Messages: 400
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 ?

Re: Renaming a table [message #654855 is a reply to message #654851] Tue, 16 August 2016 03:48 Go to previous messageGo to next message
John Watson
Messages: 8558
Registered: January 2010
Location: Global Village
Senior Member
A "renamed" table is not a "newly created" table. Which is it?
Re: Renaming a table [message #654875 is a reply to message #654855] Tue, 16 August 2016 06:26 Go to previous messageGo to next message
saipradyumn
Messages: 400
Registered: October 2011
Location: Hyderabad
Senior Member
My intention renamed table (not newly created )
Re: Renaming a table [message #654878 is a reply to message #654875] Tue, 16 August 2016 06:35 Go to previous messageGo to next message
Littlefoot
Messages: 21674
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Can't you just test it? It is really a simple task ...
Re: Renaming a table [message #654881 is a reply to message #654878] Tue, 16 August 2016 07:28 Go to previous messageGo to next message
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.
Re: Renaming a table [message #654952 is a reply to message #654881] Wed, 17 August 2016 07:23 Go to previous messageGo to next message
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 Go to previous message
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.
Previous Topic: PL/SQL: ORA-00942: table or view does not exist
Next Topic: previous data
Goto Forum:
  


Current Time: Sat Jun 12 21:37:48 CDT 2021