Oracle sysnoyms internal [message #522070] |
Tue, 06 September 2011 06:06 |
dba_7722
Messages: 197 Registered: August 2010 Location: Delhi
|
Senior Member |
|
|
Hello Expert,
Does Oracle synonyms store table object_id or it store row_id when created..?? I request if you please explain internal of Oracle synonyms.
Thanks
Jay vardhan
|
|
|
|
|
|
|
Re: Oracle sysnoyms internal [message #522087 is a reply to message #522081] |
Tue, 06 September 2011 07:09 |
|
Michel Cadot
Messages: 68716 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
1/ You said: "stop working when we rebuild the table or move the table to other tablespace." and now you rename, this is not the same thing.
2/ I said: "It creates a row [...] in SYS.SYN$ for the synonym with the owner, name and node of the target object.
Is this not clear why the synonym no more works when you rename?
Regards
Michel
[Updated on: Tue, 06 September 2011 07:11] Report message to a moderator
|
|
|
|
|
|