Does that mean the definition of database of Oracle is different from SQL
server. SQL server seperates one db (db1) from another db (db2). db1 has a
number of objects seperate from db2 (which too has a number of objects under
it). But as I've understood in the case of Oracle a db is an instance under
which it may have different databases. It doesn't seperate database as SQL
server does. But logically in tablespaces(inside which it has several
objects as tables, procedures etc.?
Do I've a point here?
SP
<ddf_dba_at_my-deja.com> wrote in message news:8jj0sm$reh$1_at_nnrp1.deja.com...
> 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.
>
Received on Fri Jun 30 2000 - 00:00:00 CDT
