Re: Newbie ques: Oracle Instance

From: Ryan S <rshevchi_at_vt.edu>
Date: 1 Aug 2005 09:37:47 -0700
Message-ID: <1122914266.975568.167610@g43g2000cwa.googlegroups.com>

leostar10 wrote:
> Hi,
> Iam new to Oracle and would appreciate any clarifications on
> these doubts I have:
>
> 1. Iam reading the documentation and it says that Oracle DB Server is
> basically Oracle Database and Oracle instance. What I understand is
> there is one Oracle DB and there can be 1 or more Oracle instances. So
> my question is, when can there be more than one Oracle instances?
>

RAC
> 2. Is there always a one-to-one relationship between a schema name and
> the username?

Yes
>
> 3. Can the actual data corresponding to a Schema be in one datafile or
> it can be shared in more than one datafiles and also can a datafile
> contain the information pertaining to more than one schemas?

You set the user/schema to have a default tablspace that can have more that one datafile. Multiple users can use the same tablespace, so yes.

>
> Thanks!
Received on Mon Aug 01 2005 - 11:37:47 CDT