Obtaining a list of all databases via SQL - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 16 of 16

Thread: Obtaining a list of all databases via SQL

  1. #11
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    but really the question - how can i tell what databases are on my server, only arises when it isn't properly managed. Or you have taken over management and not got any docs or anyone who knows

  2. #12
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    That is absolutely true.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #13
    Join Date
    Feb 2003
    Location
    London
    Posts
    170
    I know this is not sql but in unix, you could do a
    ps -ef |grep oracle - this will show all the oracle database processes running
    or even still
    ps -ef |grep smon

  4. #14
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    and 2 of my databases are shut down - but they are still there?

    Or I could even have an instance but no database

  5. #15
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Can we all agree that if we were required to use SQLPLUS ONLY to determine the databases on a system, we'd ask for our coat and hat.

    (and recommend they use sql server?)

    Maybe we should just let this thread unravel. It was good, stimulating thought.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  6. #16
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    deal

Posting Permissions

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


Click Here to Expand Forum to Full Width