RE: ORA-04030 error

From: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Mon, 17 Sep 2001 10:56:59 -0700
Message-ID: <F001.003908E3.20010917101022@fatcity.com>

<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_at_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_at_fatcity.com" title=ORACLE-L_at_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_at_hotmail.com">bigplanet34_at_hotmail.com>To: 
      Multiple recipients of list ORACLE-L <<A 
      href="mailto:ORACLE-L_at_fatcity.com">ORACLE-L_at_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> Received on Mon Sep 17 2001 - 12:56:59 CDT