AllExperts > Oracle 
Search      
Oracle
Volunteer
Answers to thousands of questions
 Home · More Oracle Questions · Answer Library  · Encyclopedia ·
More Oracle Answers
Question Library

Ask a question about Oracle
Volunteer
Experts of the Month
Expert Login

Awards

About Us
Tell friends
Link to Us
Disclaimer

 
 
 
 
About Elliot Mak
Expertise
I can answer questions with regarding to Oracle DB (8i, 9i, 10g) installation, configuration, administration, Data Guard, SQL, and PL/SQL (Procedures, triggers, functions).

Experience
I am an Oracle DBA, Senior PA, Project Manager, and Data Architect with 10 years of experience.

Education/Credentials
BS in MIS

 
   

You are here:  Experts > Computing/Technology > Oracle > Oracle > oracle database

Oracle - oracle database


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

Ask a Question


 
User Agreement | Privacy Policy | Kids' Privacy Policy | Help
Copyright  © 2008 About, Inc. AllExperts, AllExperts.com, and About.com are registered trademarks of About, Inc. All rights reserved.