I got Oracle database scripts to create the entire database of an application, including sentences to create tables, sequences, synonyms, insertions and data updates, etc.
I have to make sure that all these sentences have the name of the schema before the name of the table, for example.
INSERT IN SCHEMANAME.MYTABLE ...
I have to check this for every sentence, whether it's creations, insertions, foreign keyphrases, and so on.
And here's the question: "Is there a way to do this kind of audit? maybe through the sqldeveloper tool setting a specific configuration?
Maybe the right question here could also be, if there is a way to run the script and display an error when the executed sentence does not have the schema name included?
Thanks in advance.