Oracle-L: RE: I've got that sinking feeling...

From: <Scott.Shafer_at_dcpds.cpms.osd.mil>
Date: Mon, 25 Mar 2002 07:43:22 -0800
Message-ID: <F001.00432004.20020325074322@fatcity.com>

>From Metalink:

symptom: SP2-0642: SQL*Plus internal error state 2133, context 0:0:0

     cause: <bug:1746523>
     which is a duplicate of <bug:1358043>
     this is caused by 
     the SQL statement contained in the redo having trailing NULL columns.
These 
     trailing NULL columns are not stored in the redo record.

fix:
Upgrade to Oracle 9.0.1 or apply the 8.1.7.2 patchset.

Scott Shafer
San Antonio, TX
210-581-6217

"Common sense will not accomplish great things. Simply become insane and desperate."

> -----Original Message-----
> From: Seefelt, Beth [SMTP:Beth.Seefelt_at_tetleyusa.com]
> Sent: Friday, March 22, 2002 7:38 PM
> To: Multiple recipients of list ORACLE-L
> Subject: I've got that sinking feeling...
>
>
> Does anyone know what this error means ? No traces, nothing in the alert
> log.
>
> SP2-0642: SQL*Plus internal error state 2133, context 0:0:0
> Unsafe to proceed
>
> TIA,
>
> Beth
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Seefelt, Beth
> INET: Beth.Seefelt_at_TetleyUSA.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Scott.Shafer_at_dcpds.cpms.osd.mil

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 Mon Mar 25 2002 - 09:43:22 CST