From NDATFM@labor.state.ny.us Mon, 17 Sep 2001 10:56:59 -0700
From: "Mercadante, Thomas F" <NDATFM@labor.state.ny.us>
Date: Mon, 17 Sep 2001 10:56:59 -0700
Subject: RE: ORA-04030  error
Message-ID: <F001.003908E3.20010917101022@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain



<SPAN 
class=434190317-17092001>BigP,
<SPAN 
class=434190317-17092001> 
Have 
you increased your Shared_Pool_Size param?
<SPAN 
class=434190317-17092001> 
Stored 
procedures live in the Shared Pool.  Maybe you shared pool is too 
small.
<SPAN 
class=434190317-17092001> 
<SPAN 
class=434190317-17092001>Increase it, and try your import 
again.
<SPAN 
class=434190317-17092001> 
<SPAN 
class=434190317-17092001>LittleT
 
Tom Mercadante <FONT face=Arial 
size=2>Oracle Certified Professional 

  <FONT face=Tahoma 
  size=2>-----Original Message-----From: Big Planet 
  [mailto:bigplanet34@hotmail.com]Sent: Monday, September 17, 2001 
  1:00 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Re: ORA-04030 error
  Yes .
  <BLOCKQUOTE dir=ltr 
  style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
    ----- Original Message ----- 
    <DIV 
    style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: 
    Jeram 
    To: <A 
    href="mailto:ORACLE-L@fatcity.com" title=ORACLE-L@fatcity.com>Multiple 
    recipients of list ORACLE-L 
    Sent: Sunday, September 16, 2001 8:10 
    PM
    Subject: Re: ORA-04030 error
    
    Have applied oracle Patch set for 
    8.1.7.?
     
    Rgds/jeram
    <BLOCKQUOTE 
    style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px">
      -----Original Message-----From: 
      Big Planet <<A 
      href="mailto:bigplanet34@hotmail.com">bigplanet34@hotmail.com>To: 
      Multiple recipients of list ORACLE-L <<A 
      href="mailto:ORACLE-L@fatcity.com">ORACLE-L@fatcity.com>Date: 
      Saturday, September 15, 2001 8:13 AMSubject: ORA-04030 
      error
      Hi All 
      ,
      I am getting this error 
      <FONT 
      size=2>ORA-04030  out of memory when 
      importing in 8.1.7 Solaris 8 .  There is no data in import it is just 
      empty tables and stored procs .The error comes with one stored proc 
      .
      Any Idea how this can be solved 
      .
       
      TIA ,
      -BigP
      <FONT face=Arial 
    size=2>