Home » RDBMS Server » Server Administration » Oracle 10G schema
Oracle 10G schema [message #364352] Mon, 08 December 2008 02:45 Go to next message
anshulk
Messages: 12
Registered: December 2008
Junior Member
I have Oracle 10G installed on my system. How do I find out what all databases and schemas are present?
Re: Oracle 10G schema [message #364353 is a reply to message #364352] Mon, 08 December 2008 02:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database: What is your OS?
Schema: Connec to the database and query all_users

Regards
Michel
Re: Oracle 10G schema [message #364361 is a reply to message #364353] Mon, 08 December 2008 03:12 Go to previous messageGo to next message
anshulk
Messages: 12
Registered: December 2008
Junior Member
OS is Windows 2003
Re: Oracle 10G schema [message #364363 is a reply to message #364353] Mon, 08 December 2008 03:14 Go to previous messageGo to next message
anshulk
Messages: 12
Registered: December 2008
Junior Member
It gives the list of users, not the schema in which these users are created.
Re: Oracle 10G schema [message #364366 is a reply to message #364363] Mon, 08 December 2008 03:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Check the "OracleServiceXXXX" service in Windows Services (program or registry)

2/ In Oracle, schema and user are the same (but for advanced configuration you surely not use).

Regards
Michel
Re: Oracle 10G schema [message #364368 is a reply to message #364366] Mon, 08 December 2008 03:27 Go to previous message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Given the 2 questions you posted today, I recommend you to read Database Concepts

Regards
Michel
Previous Topic: Table analysed
Next Topic: very confusing situation
Goto Forum:
  


Current Time: Wed Dec 07 08:22:07 CST 2016

Total time taken to generate the page: 0.06849 seconds