Hi,
Iam new to Oracle and would appreciate any clarifications on
these doubts I have:
- 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?
- Is there always a one-to-one relationship between a schema name and
the username?
- 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?
Thanks!
Received on Mon Aug 01 2005 - 11:05:42 CDT
