Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Basic Oracle Concepts

Re: Basic Oracle Concepts

From: <sybrandb_at_yahoo.com>
Date: 28 Jul 2005 04:47:35 -0700
Message-ID: <1122551255.818339.55450@g44g2000cwa.googlegroups.com> 





No, one instance manages one database. Period.
You have

                        instance


                         |

                         |

                        database


                         |

      ---------------------------------------
      |                                      |
   scott schema                   hr schema





That is 2 schemata in 1 database.




Users are connected to a *database*, NOT to a *schema*, and they can
access whatever schema, they have been allowed to access.

-- 
Sybrand Bakker
Senior Oracle DBA


Received on Thu Jul 28 2005 - 06:47:35 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US