| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_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_at_irs.gov
704-569-1002 x107
------_=_NextPart_001_01C028BD.1469CA42
Content-Type: text/html;
charset="ISO-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1">
<TITLE>34 databases to 1 database</TITLE>
<META content="MSHTML 5.00.3103.1000" name=GENERATOR></HEAD>
<BODY>
<DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=209075419-27092000>So
whats the problem ( aside from the disks - AND - schema management issues )<SPAN
class=620525519-27092000>?</SPAN> It should do quite
well.</SPAN></FONT></DIV></DIV>
<BLOCKQUOTE>
<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Webber Valerie H
[mailto:Valerie.H.Webber_at_irs.gov]<BR><B>Sent:</B> Wednesday, September 27,
2000 1:26 PM<BR><B>To:</B> Multiple recipients of list
ORACLE-L<BR><B>Subject:</B> 34 databases to 1 database<BR><BR></DIV></FONT>
<P><FONT color=#800000 face="Bookman Old Style">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. </FONT></P>
<P><FONT color=#800000 face="Bookman Old Style">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.</FONT></P>
<P><FONT color=#800000 face="Bookman Old Style">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...)</FONT></P>
<P><FONT color=#800000 face="Bookman Old Style">Thanks in advance!</FONT>
<BR><FONT color=#800000 face="Bookman Old Style">Val</FONT> <BR><B><FONT
color=#000080 face=Verdana>Valerie H. Webber</FONT><FONT color=#000000
face=Verdana></FONT></B><BR><FONT color=#000080 face="Comic Sans MS" size=1>Management Systems Designers, Inc</FONT> <BR><FONT color=#000080 face="Comic Sans MS" size=1>Database Administrator</FONT><FONT color=#000000 face=Arial><BR></FONT><FONT color=#000080 face="Comic Sans MS" size=1>Valerie.H.Webber_at_irs.gov</FONT><FONT color=#000000 face=Arial><BR></FONT><FONT color=#000080 face="Comic Sans MS" size=1>704-569-1002 x107</FONT><FONT color=#000000 face=Arial>
 |
 |