Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: cannot truncate a table
--0-2044897763-962041378=:9298
Content-Type: text/plain; charset=us-ascii
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.
>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).
>
-- 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! --0-2044897763-962041378=:9298 Content-Type: text/html; charset=us-ascii <P> Was the table created with any lower case characters in the name? If so, be sure to enclose the name in double quotes...</P> <P>ex. drop table "MyTable";<BR></P> <P> <B><I>"Singla, Sanjeev" <SSingla_at_oxhp.com></I></B> wrote: <BR> <BLOCKQUOTE style="BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px">How did u fix it ? Was that the issue I mentioned or something else ?<BR>Sanjeev<BR><BR>-----Original Message-----<BR>Sent: Monday, June 26, 2000 1:15 PM<BR>To: Multiple recipients of list ORACLE-L<BR><BR><BR>Thanks Singla, The problem fixed. I really appreciate your input.<BR>----------------------------------------------<BR>Original Message<BR>Date: Mon, 26 Jun 2000 06:27:03 -0800<BR><BR>>This looks like a problem in dictinary tables. Sometimes , the dictionary<BR>>tabes does'nt match. eg. Table is there in dba_table,dba_segments but entry<BR>>missing <BR>>from dba_extents or vice versa. In such cases u can do some operations and<BR>>some fails.<BR>>Oracle Corp. does have some queries on internal tables which can fix them<BR>by<BR>>updating<BR>>the sys tables values.<BR>><BR>>Sanjeev<BR>><BR>>-----Original Message-----<BR>>Sent: Friday, June 23, 2000! 7:10 PM<BR>>To: Multiple recipients of list ORACLE-L<BR>><BR>><BR>>Hi List,<BR>><BR>>When I try to truncate a table, I am getting:<BR>>ora-00604: error occurred at recursive sql level 1<BR>>ora-00942: table or view does not exist<BR>><BR>>I am the owner of this table and have no problem to drop this table.<BR>><BR>>Please help!!<BR>><BR>>Cydnee<BR>><BR>><BR>>_____________________________________________<BR>>Free email with personality! Over 200 domains!<BR>>http://www.MyOwnEmail.com<BR>><BR>>-- <BR>>Author: <BR>> INET: cw@netlimit.com<BR>><BR>>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051<BR>>San Diego, California -- Public Internet access / Mailing Lists<BR>>--------------------------------------------------------------------<BR>>To REMOVE yourself from this mailing list, send an E-Mail message<BR>>to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>>! ;the message BODY, include a line containing: UNSUB ORACLE-L<BR>>(or the name of mailing list you want to be removed from). You may<BR>>also send the HELP command for other information (like subscribing).<BR>>-- <BR>>Author: Singla, Sanjeev<BR>> INET: SSingla_at_oxhp.com<BR>><BR>>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051<BR>>San Diego, California -- Public Internet access / Mailing Lists<BR>>--------------------------------------------------------------------<BR>>To REMOVE yourself from this mailing list, send an E-Mail message<BR>>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>>the message BODY, include a line containing: UNSUB ORACLE-L<BR>>(or the name of mailing list you want to be removed from). You may<BR>>also send the HELP command for other information (like subscribing).<BR>><BR><BR>_____________________________________________<BR>Free email with personality! Over 200 domains!<BR>ht! tp://www.MyOwnEmail.com<BR><BR>-- <BR>Author: <BR>INET: cw_at_netlimit.com<BR><BR>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051<BR>San Diego, California -- Public Internet access / Mailing Lists<BR>--------------------------------------------------------------------<BR>To REMOVE yourself from this mailing list, send an E-Mail message<BR>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the message BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing list you want to be removed from). You may<BR>also send the HELP command for other information (like subscribing).<BR>-- <BR>Author: Singla, Sanjeev<BR>INET: SSingla_at_oxhp.com<BR><BR>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051<BR>San Diego, California -- Public Internet access / Mailing Lists<BR>--------------------------------------------------------------------<BR>To REMOVE yourself from this mailing list, send an E-Mail message<BR>to: ListGuru_at_fatcity.c! om (note EXACT spelling of 'ListGuru') and in<BR>the message BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing list you want to be removed from). You may<BR>also send the HELP command for other information (like subscribing).</BLOCKQUOTE><p><br><hr size=1><b>Do You Yahoo!?</b><br> Get Yahoo! Mail - Free email you can access from anywhere!Received on Mon Jun 26 2000 - 12:42:58 CDT
![]() |
![]() |