Thanks Singla, The problem fixed. I really appreciate your input.
Original Message
From: "Singla, Sanjeev"<SSingla_at_oxhp.com>
Subject: RE: cannot truncate a table
Date: Mon, 26 Jun 2000 06:27:03 -0800
>This looks like a problem in dictinary tables. Sometimes , the dictionary
>tabes does'nt match. eg. Table is there in dba_table,dba_segments but entry
>missing
>from dba_extents or vice versa. In such cases u can do some operations and
>some fails.
>Oracle Corp. does have some queries on internal tables which can fix them
by
>updating
>the sys tables values.
>
>Sanjeev
>
>-----Original Message-----
>Sent: Friday, June 23, 2000 7:10 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Hi List,
>
>When I try to truncate a table, I am getting:
>ora-00604: error occurred at recursive sql level 1
>ora-00942: table or view does not exist
>
>I am the owner of this table and have no problem to drop this table.
>
>Please help!!
>
>Cydnee
>
>
>_____________________________________________
>Free email with personality! Over 200 domains!
>http://www.MyOwnEmail.com
>
>--
>Author:
> INET: cw_at_netlimit.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).
>--
>Author: Singla, Sanjeev
> INET: SSingla_at_oxhp.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).
>
Free email with personality! Over 200 domains!
Received on Mon Jun 26 2000 - 11:02:14 CDT
