Re: cannot truncate a table

From: Suhen Pather <pathers5_at_telkom.co.za>
Date: Mon, 26 Jun 2000 08:44:54 +0200
Message-Id: <10539.110386@fatcity.com>

Hi There

Check if you have drop table privilege.
You need the drop table priv to drop a table in your schema. If it is in another users schema make sure you have drop any table = privilege or you are able to drop that table.

Once we have experienced a problem which gave an error of=20
> ora-00604: error occurred at recursive sql level 1
> ora-00942: table or view does not exist

We later discovered that there was a datafile which was corrupt. It could be a block corruption or datafile corruption. Shutdown the database and restart.
But before doing that try to test other tables which are on the same = datafile as the one which the table is giving the recursive SQL error. Try to create a table in that tablespace.

If you get errors you can almost be certain that there is some level of = corruption.

Try shutdown the database and restart.
Recover from a backup if you have one.

Regards
Suhen Pather
Oracle DBA
Telkom SA

>>> zaschke_at_suas.cz 06/26/00 08:14AM >>> Do you truncate the table manualy or in a job? If it is done in a job, is the job runnig under your user's schema?

cw_at_netlimit.com p=ED=B9e:

>=20

> Hi List,

>=20

> 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

>=20

> I am the owner of this table and have no problem to drop this table.

>=20

> Please help!!

>=20

> Cydnee

>=20


> _____________________________________________

> Free email with personality! Over 200 domains!
> http://www.MyOwnEmail.com=20

>=20

> --
> Author:
> INET: cw_at_netlimit.com=20

>=20


> 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).

--=20

 Ing. Michal Zaschke          =20
   DB Administrator            =20

Sokolovska uhelna, a.s.
phone: +420 168 645417
e-mail: zaschke_at_suas.cz=20
--=20
Author: Michal Zaschke
  INET: zaschke_at_suas.cz=20

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 Received on Mon Jun 26 2000 - 01:44:54 CDT