Message-Id: <10632.118050@fatcity.com> From: Webber Valerie H Date: Wed, 27 Sep 2000 15:21:55 -0400 Subject: 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@irs.gov 704-569-1002 x107 ------_=_NextPart_001_01C028B8.36AF19F4 Content-Type: text/html; charset="ISO-8859-1" Content-Transfer-Encoding: quoted-printable 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_01C028B8.36AF19F4-- ------------------------------ From: Viktor 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. --- Kader Ben wrote: > Hi friend, > I have created trigger (see code below) to > insert > some values into table. But this generate ORA-4091 > error (mutating table). > Could someone suggest me a workaround? > Thank you in advance for your help. > > Kader