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: Oracle second instance

Re: Oracle second instance

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 12 Jun 2002 12:55:59 +0100
Message-ID: <3d0736d0$0$232$ed9e5944@reading.news.pipex.net>


"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

Original text of this message

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