Can I use a Synonym to point to an object in a schema using another schema? I don't have too much experience in Oracle, so I am sorry if this is a simple question.

I have to move many objects in the database from one schema to another.
I am trying to update all dependencies as well, but just to be in the safe side I would like to leave behind a link.

Example:


Right now I have in my Schema 1 (S1) a MyTable.
Users reference it like:

S1.MyTable
I would like to move MyTable to Schema 2 (S2)

S2.MyTable
I would like my users to be able to still use MyTable as they used to.

S1.MyTable /MyTable is really in S2, but users can access it with S1/


I have been reading about Synonyms and it seems you can create public ones so users can reference an object directly, like:

MyTable


But I need them to be able to write S1.MyTable

Can I use synonyms for this?
Yes, of course. You just need to create synonym in S1 schema (not public synonym).