Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Synonym Metadata

richardgundersen-JavaNetOct 4 2007 — edited Oct 4 2007
Hi

Is it possible to work out which database/schema an Oracle Synonym is pointing at via the ResultSetmetaData object (or any other means)?

We have lots of schemas and sometimes my synonyms get set up pointing at the wrong database. I'd like to be able to write a test that checks this information.

Thanks!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 1 2007
Added on Oct 4 2007
3 comments
995 views