OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Oracle 10G schema

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle 10G schema [message #364352]

Mon, 08 December 2008 02:45

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?

Report message to a moderator

Re: Oracle 10G schema [message #364353 is a reply to message #364352]

Mon, 08 December 2008 02:47

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Database: What is your OS?
Schema: Connec to the database and query all_users

Regards
Michel

Report message to a moderator

Re: Oracle 10G schema [message #364361 is a reply to message #364353]

Mon, 08 December 2008 03:12

anshulk
Messages: 12
Registered: December 2008

Junior Member

OS is Windows 2003

Report message to a moderator

Re: Oracle 10G schema [message #364363 is a reply to message #364353]

Mon, 08 December 2008 03:14

anshulk
Messages: 12
Registered: December 2008

Junior Member

It gives the list of users, not the schema in which these users are created.

Report message to a moderator

Re: Oracle 10G schema [message #364366 is a reply to message #364363]

Mon, 08 December 2008 03:25

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Oracle 10G schema [message #364368 is a reply to message #364366]

Mon, 08 December 2008 03:27

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Given the 2 questions you posted today, I recommend you to read Database Concepts

Regards
Michel

Report message to a moderator

Previous Topic:	Table analysed
Next Topic:	very confusing situation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 05 16:42:26 CST 2024