Home » SQL & PL/SQL » SQL & PL/SQL » How many schemas in my bd? (oracle 10.2.0.2)
How many schemas in my bd? [message #305388] Mon, 10 March 2008 10:47 Go to next message
bonovox
Messages: 6
Registered: February 2006
Junior Member
Hi,

How can I find how many schemas there are in a DB using a sql query?


Thanks


Bonovox
Re: How many schemas in my bd? [message #305394 is a reply to message #305388] Mon, 10 March 2008 11:00 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Depending on what you mean with "schema":
dba_users
dba_objects
dba_segments

Regards
Michel
Re: How many schemas in my bd? [message #305396 is a reply to message #305394] Mon, 10 March 2008 11:03 Go to previous message
bonovox
Messages: 6
Registered: February 2006
Junior Member
dba_objects
Previous Topic: Columns to Rows(New Rows)
Next Topic: Creating Procedure error
Goto Forum:
  


Current Time: Fri Dec 09 01:42:07 CST 2016

Total time taken to generate the page: 0.08592 seconds