On the other side of the scale, does the new application need data from the old one? If yes, are snapshots acceptable or do you need real-time data? Queries involving database links are often a nightmare (even on the same server).
On a single server, memory and disk consumption favour separate schemas.
>----- ------- Original Message ------- -----
>From: Stephen Lee <Stephen.Lee_at_DTAG.Com>
>To: Multiple recipients of list ORACLE-L
><ORACLE-L_at_fatcity.com>
>Sent: Thu, 17 Apr 2003 08:26:41
>
>
>Here's a couple:
>
>If you need public synonyms, and the two
>applications might have objects
>with the same name.
>
>Security problems with having the users from both
>applications logging in to
>the same database.
>
>
>-----Original Message-----
>
>What would be the thought pattern when trying to
>determine whether to put a
>new application's data under a new instance vs.
>putting it into an existing
>instance with a new schema?
>
>--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephane Faroult
INET: sfaroult_at_oriolecorp.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu Apr 17 2003 - 12:01:58 CDT
