Home » RDBMS Server » Enterprise Manager » How to Query list of Schema and User in a mounted DB
How to Query list of Schema and User in a mounted DB [message #264453] Mon, 03 September 2007 07:05 Go to next message
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.
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
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 Go to previous message
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.



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


Current Time: Fri Mar 29 10:30:53 CDT 2024