OraFAQ Forum: Enterprise Manager » How to Query list of Schema and User in a mounted DB

Home » RDBMS Server » Enterprise Manager » How to Query list of Schema and User in a mounted DB

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

How to Query list of Schema and User in a mounted DB [message #264453]

Mon, 03 September 2007 07:05

win3vin
Messages: 35
Registered: April 2007
Location: Malaysia

Member

Hi

I have a database that unable to open and can access until mounted stage only. I would like to find query on list of schema and user name in the database? any query name or dictionary I can use?

thanks.

Report message to a moderator

Re: How to Query list of Schema and User in a mounted DB [message #264515 is a reply to message #264453]

Mon, 03 September 2007 10:39

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

Senior Member
Account Moderator

You can't do this.
If the database is not open you can't access dictionay or any other data in the database data files.

Regards
Michel

Report message to a moderator

Re: How to Query list of Schema and User in a mounted DB [message #264596 is a reply to message #264453]

Mon, 03 September 2007 22:15

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

In addition , however you can use select query that don't need access data dictionary/ don't need database open.

Like, Seelct * from v$datafile

or query from v$controlfile
or from v$logfile.

Report message to a moderator

Previous Topic:	Oracle Grid job broken
Next Topic:	oemapp console error message

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 23:04:31 CST 2025