Message-ID: <F001.005006E9.20021111150848@fatcity.com>
Date: Mon, 11 Nov 2002 15:08:48 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: root@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: Tao_Zuo@npd.com
Subject: RE: combine or not combine into one database?
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

Thanks a lot for you info.  Do you know how I can subscribe the Lawson 
email list?  Thanks again.

-----Original Message-----
Sent: Monday, November 11, 2002 2:59 PM
To: ORACLE-L


Tao - If I understand your situation, you currently have 3 separate
databases, 2 separate Lawson databases and another OEM database?
	You can combine your two Lawson databases, but you'll need to
develop a careful project plan. Right now your Lawson HR database 
probably
sends data to your Lawson GL system, so that needs looked at before you 
do
the combination. There is a Lawson email list that can answer that 
question
in more detail.
	Is the OEM repository and historical database more of a data
warehouse or OLTP system? Data warehouses tend to have spikey usage and
don't play well with OLTP databases such as your Lawson system. I would 
tend
to keep it separate just based on the limited information you've 
provided.

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams@lifetouch.com 


-----Original Message-----
Sent: Monday, November 11, 2002 11:04 AM
To: Multiple recipients of list ORACLE-L


Hi all,

I would like to know any advantage and disadvantage to combine the 
following databases into one:

Finance in Lawson
HR in Lawson
OEM repository and historical database

Any comments are very appreciated.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Tao_Zuo@npd.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@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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS@LIFETOUCH.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@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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Tao_Zuo@npd.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@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).