RE: combine or not combine into one database?

2002-11-14 Thread Tao_Zuo
I send a e-mail to the address and get no respond so far.  Any other 
solution?  Thanks a lot.  - Tao

-Original Message-
Sent: Tuesday, November 12, 2002 7:19 AM
To: ORACLE-L


Tao - I believe you send any mail to:
 mailto:lawson_sysadmin-subscribe@;topica.com 

If that doesn't work, let me know.

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Monday, November 11, 2002 5:09 PM
To: Multiple recipients of list ORACLE-L


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.
[EMAIL PROTECTED] 


-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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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 othe

RE: combine or not combine into one database?

2002-11-12 Thread DENNIS WILLIAMS
Tao - I believe you send any mail to:
 mailto:lawson_sysadmin-subscribe@;topica.com 

If that doesn't work, let me know.

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Monday, November 11, 2002 5:09 PM
To: Multiple recipients of list ORACLE-L


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.
[EMAIL PROTECTED] 


-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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).



RE: combine or not combine into one database?

2002-11-11 Thread Tao_Zuo
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.
[EMAIL PROTECTED] 


-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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).



RE: combine or not combine into one database?

2002-11-11 Thread DENNIS WILLIAMS
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.
[EMAIL PROTECTED] 


-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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).