ORA-04030 - Is it CLOB problem?

From: Prasad BAV <bavprasad_oracle_at_yahoo.com>
Date: Fri, 09 Nov 2001 23:11:28 -0800
Message-ID: <F001.003C182D.20011109224517@fatcity.com>

Hi List,

We are using Oracle 8.1.7 on Windows 2000. System RAM is 3GB. We are using 1.5GB of SGA. System is 1GHz processor.

We are getting sometimes problem with the error ORA-04030. Our DBA says this is the problem because of bug with Oracle 8.1.7 in Windows 2000 with CLOB datatype. We have developed our application with lot of CLOB usage.

Is that true? Do we have an alternative to avoid that error? Or do we have to change the data type? Please suggest us.

Thanks in advance,

Regards,

Prasad BAV.

Do You Yahoo!?
Find a job, post your resume.
http://careers.yahoo.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Prasad BAV
INET: bavprasad_oracle_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Sat Nov 10 2001 - 01:11:28 CST