How to get list of databases in Oracle? [modified]
Database
3
Posts
3
Posters
0
Views
1
Watching
-
Does anybody know how to get List of Databases in Oracle? -- modified at 7:53 Tuesday 20th March, 2007
Nana
-
select * from sysdatabases; but this statement should be master DB
Regards, Smart Boy Mumbai, (INDIA)
Actually, the poster asked for a solution for Oracle. sysdatabases is for SQL Server (and possibly Sybase?). The concept of server/database is different for Oracle versus SQL Server, meaning I'm not sure of an Oracle solution (assuming you actually did mean database). You might have to look at parsing the tnsnames.ora file or something. I'll post again if I find anything. Scott