Re: newbie question

Answers embedded

Hth,

Sybrand Bakker, Oracle DBA

"SP" <spant1_at_aol.com> wrote in message
news:Edb75.919$0x.28452_at_nuq-read.news.verio.net...
> Does that mean the definition of database of Oracle is different from SQL
> server.

Yes!!!

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.

Basically a sql server database is an Oracle schema

But logically in tablespaces(inside which it has several
> objects as tables, procedures etc.?
> Do I've a point here?

Yes and no. You could still have different 'databases'/schema all in one tablespace, though that's not recommended. You should use distinct tablespaces, preferably at least one for tables and one for indexes per schema/application.

> 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 Sat Jul 01 2000 - 00:00:00 CDT