| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_01C028B8.36AF19F4
Content-Type: text/plain;
charset="ISO-8859-1"
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_01C028B8.36AF19F4
Content-Type: text/html;
charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DISO-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>34 databases to 1 database</TITLE>
</HEAD>
<BODY>
<P><FONT COLOR=3D"#800000" FACE=3D"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=3D"#800000" FACE=3D"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=3D"#800000" FACE=3D"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=3D"#800000" FACE=3D"Bookman Old Style">Thanks in =
advance!</FONT>
<BR><FONT COLOR=3D"#800000" FACE=3D"Bookman Old Style">Val</FONT>
<BR><B><FONT COLOR=3D"#000080" FACE=3D"Verdana">Valerie H. =
Webber</FONT><FONT COLOR=3D"#000000" FACE=3D"Verdana"></FONT></B><BR>
<FONT COLOR=3D"#000080" SIZE=3D1 FACE=3D"Comic Sans MS">Management =
Systems Designers, Inc</FONT>
<BR><FONT COLOR=3D"#000080" SIZE=3D1 FACE=3D"Comic Sans MS">Database =
Administrator</FONT><FONT COLOR=3D"#000000" FACE=3D"Arial"><BR>
</FONT><FONT COLOR=3D"#000080" SIZE=3D1 FACE=3D"Comic Sans =
MS">Valerie.H.Webber_at_irs.gov</FONT><FONT COLOR=3D"#000000" =
FACE=3D"Arial"><BR>
</FONT><FONT COLOR=3D"#000080" SIZE=3D1 FACE=3D"Comic Sans =
MS">704-569-1002 x107</FONT><FONT COLOR=3D"#000000" FACE=3D"Arial"> =
</FONT>
</P>
<BR>
</BODY>
</HTML>
------_=_NextPart_001_01C028B8.36AF19F4--
From: Viktor <stant_98_at_yahoo.com>
Date: Wed, 27 Sep 2000 12:23:30 -0700 (PDT)
Subject: Re: mutating table
--0-327254586-970082610=:11462
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Oracle does not allow you to perform DML statements on the target source table in a row level trigger. You can either use a temp table to get modified data from or write a package you''ll find in attachement.
 |
 |