Chuck, It was a problem with the public synonym. The synonym created
with the same name as the table. The DDL became DL.
Original Message
From: "Chuck Hamilton"<chuck_hamilton_at_yahoo.com>
Subject: RE: cannot truncate a table
Date: Mon, 26 Jun 2000 10:42:58 -0700 (PDT)
>
> Was the table created with any lower case characters in the name? If so,
be sure to enclose the name in double quotes...
>
>ex. drop table "MyTable";
>
>
> "Singla, Sanjeev" <SSingla_at_oxhp.com> wrote:
>How did u fix it ? Was that the issue I mentioned or something else ?
>Sanjeev
>
>-----Original Message-----
>Sent: Monday, June 26, 2000 1:15 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Thanks Singla, The problem fixed. I really appreciate your input.
>----------------------------------------------
>Original Message
>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!
>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).
>
>
>---------------------------------
>Do You Yahoo!?
>Get Yahoo! Mail - Free email you can access from anywhere!
>
Received on Mon Jun 26 2000 - 13:13:10 CDT
