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.
Right now I have in my Schema 1 (S1) a MyTable. Users reference it like:
I would like to move MyTable to Schema 2 (S2)
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:
But I need them to be able to write S1.MyTable
Can I use synonyms for this?