Is there a "universal unique identifier" for the ASA12-database?
asked 25 Feb '15, 06:18
Then the following FAQs may be of help:
However, these FAQs do not deal with the question whether the running database is the "right" one, i.e. whether the correct database file has been loaded. Say, if you have 10 different databases with the same schema, they don't tell if the desired database (say, here database 3) has been loaded. In case you know the file location then db_property('File') may help.
For databases used with replication/synchronization, they usually can be identified via CURRENT PUBLISHER or the remote ID. For general purpose databases, I would think you would have to "label" them yourself, e.g. via a user-defined SET OPTION.
answered 25 Feb '15, 07:16