RE: Truncate table-Shared pool not sufficient!

My guess would be that you are just running out of memory when Oracle is trying to complete the process. Try to increase the size of your sga. Kev

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of B N RAMAMOHAN
Sent: Monday, December 11, 2000 8:06 AM
To: Multiple recipients of list ORACLE-L Subject: Truncate table-Shared pool not sufficient!

Hi,

I was trying to truncate a table which has a LONG RAW column. It has around 2000 records. After 20 minutes it gave the error which was something like "Shared pool size is not sufficient"
(I dont know the error number/exact mesg now :( ).

Why did I get this error eventhough I was TRUNCATING the table?

Table desc is as follows:

Name                            Null?    Type
------------------------------- -------- ----
BLOB_PERSON_ID                  NOT NULL VARCHAR2(30)
BLOB_IMAGE_ID                   NOT NULL VARCHAR2(3)
BLOB_SEGMENT_NO                 NOT NULL VARCHAR2(3)
BLOB_FORMAT                     NOT NULL VARCHAR2(1)
BLOB_SEGMENT                    NOT NULL LONG RAW
BLOB_SEG_OFFSET                 NOT NULL VARCHAR2(10)
BLOB_TOTAL_SIZE                 NOT NULL VARCHAR2(10)

Regards,
Mohan

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: B N RAMAMOHAN
  INET: ramamohan.bn_at_tatainfotech.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).