Re: newbie question

In article <ED675.887$0x.27393_at_nuq-read.news.verio.net>,   "SP" <spant1_at_aol.com> wrote:
> how can I check if I have other databases on the current instance?
> SP
>
>

In many circles a 'database' is the same as an 'instance'; we shall embrace this particular view.

That being said there may be a number of schemas (collections of database objects owned by a single user) in a given instance. A quick way to find out who owns objects in the current instance is:

select distinct owner from all_objects;

This will display every user account in the instance that has created, or 'owns', one or more objects; essentially this is a list of the available schemas in the instance. A bit more information can be gleaned by adding the object_type and count to the results:

select owner, object_type, count(*)
from all_objects
group by owner, object_type;

Now it can be seen how many of which type of object a particular user 'owns'.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.