It is excellent for staging mock tables when testing. For example, if your source tables contain millions of records and you want to test a small subset of data, you can use synonyms to re-direct the source table to a smaller table you control so you can stage various scenarios. In this way, you can … Read more
Okay, I needed something similar. The path to my output artifacts were quite long, but I wanted short target names and also benefit easily from bash-completion. Here is what I’m came up with: os := [arbitrary long path to an artifact] platform := [arbitrary long path to a differ artifact] packer := [common parts of … Read more
Create a database with the name you want to impersonate. Re-jigg the DDL code generator to create a view for every table in the database that has the tables I need to access via the hardcoded name. Basically, each view will have a statement that looks like this.. CREATE VIEW schemaname.tablename as SELECT * FROM … Read more
As it turns out, the problem wasn’t actually a looping chain of synonyms, but the fact that the synonym was pointing to a view that did not exist. Oracle apparently errors out as a looping chain in this condition.