Results 1 to 10 of 10
  1. #1
    Join Date
    Nov 2003
    Posts
    9

    Question Unanswered: Basic question Urgent

    Hello Everybody
    Is there any SQL Statement to show or list all the available databases present
    Im using Oracle 8i
    Thanking you in an advanced
    ronan

  2. #2
    Join Date
    Nov 2003
    Location
    Rotterdam, Netherlands
    Posts
    127
    what do u mean available databases?
    to see the database details say

    SELECT * FROM V$DATABASE;

  3. #3
    Join Date
    Jul 2003
    Location
    England
    Posts
    152
    don't think there is.

    you could cd to $ORACLE_HOME/dbs - in there will be a init file for each oracle database on the box
    Regards
    Dbabren

  4. #4
    Join Date
    Nov 2003
    Posts
    9
    Originally posted by dbabren
    don't think there is.

    you could cd to $ORACLE_HOME/dbs - in there will be a init file for each oracle database on the box
    Hello DBABREN
    Im running Oracle 8i on WIn NT
    and I need to know the SQl statement to show or list all available databases present
    I tried
    SHOW DATABASES; but it didnt work out
    I would appriciatany help
    Thanks
    ronan

  5. #5
    Join Date
    Jul 2003
    Location
    England
    Posts
    152
    Ronan

    You won't get it from a 'normal' SQL statement as I don't believe that info is held within each database.

    What you could do, from within SQL, is to run a OS command using the ! characher.

    eg
    SQL>!dir <pathname>\init*.*

    should list all the init files the same way as the dir statement would

    Hope this helps
    Regards
    Dbabren

  6. #6
    Join Date
    Nov 2003
    Posts
    9
    hello dbabren
    i did exactly the same as you wrote but it gave me op like
    its does not exist
    Best Regrds
    Ronan

  7. #7
    Join Date
    Jul 2003
    Location
    England
    Posts
    152
    Did the command error, or did it tell you that there were no files found?

    If it errored - what was the message?
    Regards
    Dbabren

  8. #8
    Join Date
    Oct 2003
    Location
    St.Louis,MO
    Posts
    120
    Originally posted by ronan_40060
    hello dbabren
    i did exactly the same as you wrote but it gave me op like
    its does not exist
    Best Regrds
    Ronan
    Ronan, There should be a folder by the name of C:\orant\database, substitute your drive letter for C:\ if necessary.
    In that folder you will find file(s) something like initxxxx.ora.
    For each unique xxxx you could assume a database by that name or something similar. (Could ASSUME)
    Simply use Windows Explorer.
    --This will only work if you are on the box housing the database.

  9. #9
    Join Date
    Nov 2003
    Posts
    9
    Hello dbabren
    I received an error like
    commande inconnue ou le reste de la ligne est ignoré
    unknown command

  10. #10
    Join Date
    Jul 2003
    Location
    England
    Posts
    152
    Ronan

    try
    SQL>host dir ...

    I think ! may be UNIX specific
    Regards
    Dbabren

Posting Permissions

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