Oracle Database Discussions

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!

How to check Database string Name thru SQL PLus

Hassan R. KhanDec 10 2006 — edited Dec 11 2006

Hi All:

I am using Oracle9i Enterprise Edition Release 9.2.0.6.0.

I have restored my Production database into another machine to create Test Database.

The names of both the database is same in v$database. Although the database SID defined in tnsnames is different.

I want to know that if login thru SQL Plus on any database (Production or Test) and forgot the string name thru which I was connected, then how can I know the name database string? Any view or table have this information

Thanks

Hassan

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 8 2007

Added on Dec 10 2006

#general-database-discussions

5 comments

482 views