Oracle sysnoyms internal [message #522070] |
Tue, 06 September 2011 06:06 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
dba_7722
Messages: 197 Registered: August 2010 Location: Delhi
|
Senior Member |
![jayvardhancs](/forum/theme/orafaq/images/google.png)
|
|
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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68665 Registered: March 2007 Location: Nanterre, France, http://...
|
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
|
|
|
|
|
|