Expert: Elliot Mak - 11/5/2009

Question
Respected Sir/Mam
      I am using oracle10gXe but I am not able to see the my database name.
Is there any table which store the NAME OF all database
running on my computer  

thanks in advance

Answer
Good day San

I assume that you are using Oacle10gXE on WIndows Platform.  There is no table to store the name of all the DB on your computer.  However, in the Services (Start->Settings->Control Panel->Administrative Tools->Services), find all the services name that start with OracleService<SID>, those are the databases that are created on your computer.

For example, if you have three databases, they are DEV1, TEST1, and PROD1.  You should see OracleServiceDEV1, OracleServiceTEST1, and OracleServicePROD1 in the Services.

Hope it helps

Cheers
Elliot