The Kat's Work - Blog
Main | Blog | Registration | Login
Thursday
2024-04-25
8:12 AM
Welcome Guest | RSS
Main » 2011 » August » 23 » Oracle Check Connected database in sqlplus.
2:44 PM
Oracle Check Connected database in sqlplus.
After using the set oracle_sid method I had a few problems with connections in sqlplus. In that even though I would specify one database I would get the one set in oracle_sid. For this reason I would suggest it is good practice to run the following code after each connection just to check your are connected to the right database.

select name from v$database;


Tested in 10g and 11g.
Views: 1190 | Added by: The_Kat | Tags: 10g, 11g, Database name, Oracle | Rating: 0.0/0
Total comments: 0
Name *:
Email *:
Code *:
Login form
Adverts
Search
Calendar
«  August 2011  »
SuMoTuWeThFrSa
 123456
78910111213
14151617181920
21222324252627
28293031
Entries archive
Site friends
  • Create your own site
  • Spree4.com
  • My Blog
  • Statistics

    Total online: 1
    Guests: 1
    Users: 0
    spree4
    Copyright MyCorp © 2024
    Website builderuCoz