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

Home -> Community -> Usenet -> c.d.o.server -> Re: Please advice: Multiple Schemas or multiple db

Re: Please advice: Multiple Schemas or multiple db

From: srivenu <srivenu_at_hotmail.com>
Date: 6 Aug 2002 21:43:13 -0700
Message-ID: <1a68177.0208062043.78274878@posting.google.com> 





I would prefer seperate schema's in a single database.
But i would prefer to create the program objects (procedures,
packages, functions etc) in a single seperate schema with public
synonyms created on them.


Otherwise having them in each individual schema would result in a
maintenance nightmare in case of frequent changes.
Received on Tue Aug 06 2002 - 23:43:13 CDT












Original text of this message













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