Re: cannot truncate a table

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íše:
>
> 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).

-- 
 Ing. Michal Zaschke           
   DB Administrator             
Sokolovska uhelna, a.s.
phone: +420 168 645417