Sample Header Ad - 728x90

Creation Synonym among different db schemas

0 votes
1 answer
174 views
might seem a stupid question, but I'm pretty new to the db world. Is that a good practice to have two oracle schemas which have synonyms pointing to each other ? - like SCHEMA_A owns a SYNONYM_1 pointing to the TABLE_1 in the SCHEMA_B - and the SCHEMA_B owns a SYNONYM_2 pointing to the TABLE_2 in the SCHEMA_A Apparently technically is possible, but is that a good practice ? Does not sound as a kind of circular reference if you compare this to the "Software modules" concept ? Thanks in advance for your responses.
Asked by tetDev (1 rep)
May 6, 2022, 01:10 PM
Last activity: Jul 9, 2025, 08:05 AM