This discussion is archived
3 Replies Latest reply: Nov 23, 2012 12:55 AM by 975643 RSS

Views to check the catalog database name from target database.

975643 Newbie
Currently Being Moderated
Hi,
Please help me to find view to check the catalog database name which is connected to my target database because I am new to the current environment where I am working now and the previous DBA have done the set up having 2 catalog database. I want view to check from target database, which can show the catalog database name to which it is connected to.
We can check the catalog database name from the following ways but I want views to check it from target database.
1.TNSnames.ora
2.Any backup script connecting to catalog database.
3.From catalog database we can use rc_database view to check the databases registered with the catalog database.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points