I'm having a senior moment.
I've not worked with public synonyms that often, so I just want to make sure I have it right.
If you have two instances: Instance1 and Instance2
They both live on the same Oracle RAC cluster.
Intance1 and Instance2 both have a schema named FRED. Both of them have a Public synonym THISTABLE for FRED.THISTABLE
Now, I just want to make sure that public synonyms do NOT connect between two different instances, even if on the same RAC system, right?
Someone on Instance2 inserting into fred.thistable is ONLY for that instance, not affecting instance1 at all, correct?
To do anything like this, you'd basically need a database link between them, and could possibly have a public THISTABLE link on Instance2 pointing to FRED.THISTABLE on Instance1...but just wanting to make sure that I understand that only a dblink between the two schemas on the two instances will allow traffic/access between the two instances...and that public synonyms on their own will not transverse the instance gap, even with both instances being on the same cluster.
Again, senior moment here, and just wanting to make sure I have it straight.
Thanks in advance,
cayenne