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
Last activity: Jul 9, 2025, 08:05 AM