Message-Id: <10632.118060@fatcity.com> From: John Lewis Date: Wed, 27 Sep 2000 12:56:52 -0700 Subject: RE: 34 databases to 1 database This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C028BD.1469CA42 Content-Type: text/plain; charset="ISO-8859-1" So whats the problem ( aside from the disks - AND - schema management issues )? It should do quite well. -----Original Message----- From: Webber Valerie H [mailto:Valerie.H.Webber@irs.gov] Sent: Wednesday, September 27, 2000 1:26 PM To: Multiple recipients of list ORACLE-L Subject: 34 databases to 1 database I am working on a new project to take 34 Informix (approx. 5G each;1 is 13G) that currently run on 5 UNIX Pyramids and convert to 1 Oracle database (8.1.6) on a SUN E10K. Does anyone know of any issues to watch out for or any potential problem of having 1 database instance on Oracle and 34 schemas to reflect the current system. Does anyone know of a better solution? References to MetaLink/TechNet, etc welcomed. The SUN E10K will have 8G of memory, 8 CPUs but only 4 18G disks (I know its a nightmare with only 4 disks. Obviously a ridiculous decision made before I joined the team...) Thanks in advance! Val Valerie H. Webber Management Systems Designers, Inc Database Administrator Valerie.H.Webber@irs.gov 704-569-1002 x107 ------_=_NextPart_001_01C028BD.1469CA42 Content-Type: text/html; charset="ISO-8859-1" 34 databases to 1 database
So whats the problem ( aside from the disks - AND - schema management issues )? It should do quite well.
-----Original Message-----
From: Webber Valerie H [mailto:Valerie.H.Webber@irs.gov]
Sent: Wednesday, September 27, 2000 1:26 PM
To: Multiple recipients of list ORACLE-L
Subject: 34 databases to 1 database

I am working on a new project to take 34 Informix (approx. 5G each;1 is 13G) that currently run on 5 UNIX Pyramids and convert to 1 Oracle database (8.1.6) on a SUN E10K.

Does anyone know of any issues to watch out for or any potential problem of having  1 database instance on Oracle and 34 schemas to reflect the current system. Does anyone know of a better solution? References to MetaLink/TechNet, etc welcomed.

The SUN E10K will have 8G of memory, 8 CPUs but only 4 18G disks (I know its a nightmare with only 4 disks. Obviously a ridiculous decision made before I joined the team...)

Thanks in advance!
Val
Valerie H. Webber
Management Systems Designers, Inc
Database Administrator
Valerie.H.Webber@irs.gov
704-569-1002 x107