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
Im running Oracle 8i on WIn NT
and I need to know the SQl statement to show or list all available databases present
SHOW DATABASES; but it didnt work out
I would appriciatany help
Originally posted by ronan_40060
i did exactly the same as you wrote but it gave me op like
its does not exist
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.