Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle second instance
"Richard Foote" <richard.foote_at_bigpond.com> wrote in message
news:uVFN8.10817$Hj3.34984_at_newsfeeds.bigpond.com...
> Hi George,
>
> The short answer is yes. You may create as many databases as resources
allow
> on the one box. The databases all share the same executables but are
> independent of each other and are uniquely identified with an oracle_sid
> name.
The longer answer is it depends on what you mean by database. You may find that actually what you want is a second schema in the same database - perhaps with new tablespaces as well.
-- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ******************************************Received on Wed Jun 12 2002 - 06:55:59 CDT