Results 1 to 3 of 3

Thread: list databases

  1. #1
    Join Date
    Jan 2002
    Posts
    165

    Unanswered: list databases

    Is anybody know how one can from SQLPLUS to see list of
    databases he can connect to.

    Of course,I can see it from ENTERPRISE MANAGER,but is it there
    some command for do it,sth like
    list databases?

    Cheers,Zvonimir

  2. #2
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Thumbs up

    Here is one such way:

    $ sqlplus /nolog

    SQL*Plus: Release 8.1.7.0.0 - Production on Wed May 7 12:53:30 2003

    (c) Copyright 2000 Oracle Corporation. All rights reserved.

    SQL> !grep SID $TNS_ADMIN/tnsnames.ora | grep -v PLSExtProc
    (SID = TEST1)
    (SID = db31)
    (SID = o817)

    SQL>


    Hope that helps,

    clio_usa - OCP - DBA

    dbaclick.com

  3. #3
    Join Date
    Jan 2002
    Posts
    165

    thanks!

    Yes,it could help....
    Thnx,Zvonimir

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •