RE: ORA-04030 error

[Mercadante, Thomas F]

BigP,   Have you increased your Shared_Pool_Size param?   Stored procedures live in the Shared Pool.  Maybe you shared pool is too small.   Increase it, and try your import again.   LittleT   Tom Mercadante Oracle Certified Professional -----Original Message----- From: Big Planet [mailto:[EMAIL PROTECTED]] Sent: Monday, September 17, 2001 1:00 PM To: Multiple recipients of list ORACLE-L Subject: Re: ORA-04030 error Yes . ----- Original Message ----- From: Jeram To: 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 -----Original Message----- From: Big Planet <[EMAIL PROTECTED]> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Saturday, September 15, 2001 8:13 AM Subject: ORA-04030 error Hi All , I am getting this error 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