| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: cannot truncate a table
Hey List, FYI. I was the owner of this table, had a problem to
truncate but not drop. There were no priv or role issues, no corrupted
datafiles. When I drop/recreated this table by using exp/imp on a
different tablespace, still experienced the same Ora-942 error, I finally
realized it was a public synonym problem. The DDL became a DL. The
problem fixed by drop the synonym and recreated it with a different name.
Later,
>Suhen,
>
>I believe, you can always drop a table own by you.
>
>And I don't think - there is any privilege called 'drop table'.
>
>I know about 'drop any table' privilege.
>
>Do u think, there is any privilege called 'drop table'???
>
>If so, let me know...
>
>Thanks,
>
>Sandeep.
>Riyadh, Saudi Arabia.
>
>
> -----Original Message-----
> From: Suhen Pather [SMTP:pathers5_at_telkom.co.za]
> Sent: Tuesday, July 04, 2000 8:07 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: cannot truncate a table
>
> What error do you get???
>
> >>> Sandeep.Kurliye_at_almarai.com 07/04/00 03:44PM >>>
> DBAs,
>
> I don't think, there is any privilege called 'drop table'????? I
>know about
> ' drop any table' privilege.
>
> Please correct me....
>
> Thanks,
>
> Sandeep.
> Riyadh, Saudi Arabia.
>
> -----Original Message-----
> From: Suhen Pather [SMTP:pathers5_at_telkom.co.za]
> Sent: Monday, June 26, 2000 1:24 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: cannot truncate a table
>
> 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
> > 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íse:
> >
> > 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
> e-mail: zaschke_at_suas.cz
> --
> Author: Michal Zaschke
> INET: zaschke_at_suas.cz
>
> 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: Suhen Pather
> INET: pathers5_at_telkom.co.za
>
> 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: Sandeep Kurliye
> INET: Sandeep.Kurliye_at_almarai.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: Suhen Pather
> INET: pathers5_at_telkom.co.za
>
> 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: Sandeep Kurliye
> INET: Sandeep.Kurliye_at_almarai.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
Received on Wed Jul 05 2000 - 10:15:03 CDT
 |
 |