Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: cannot truncate a table

RE: cannot truncate a table

From: Suhen Pather <pathers5_at_telkom.co.za>
Date: Tue, 04 Jul 2000 17:50:13 +0200
Message-Id: <10548.111179@fatcity.com> 





Hi



I am not saying that there is a drop table priv.
If you want to drop/truncate  a table in your schema you can.
If you want to drop/truncate a table in another users schema you need the =
drop any table privilege.



If you have the required privilege and you cannot truncate the table then =
what error are you getting.


We can use this to determine the problem you are having.



We have experienced this once when a user cannot truncate a table within =
his own schema.


We later realised that a datafile  was corrupt.
It was the tablespace that holds his table.

         	                It gave an error
 		> ora-00604: error occurred at recursive sql level 1


		> ora-00942: table or view does not exist






This could also be a similar problem to what you are experiencing.
But then again could you please inform us of the error message.



Regards


$uhen



>>> Sandeep.Kurliye_at_almarai.com 07/04/00 06:14PM >>>
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]=20
	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]=20
		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=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=EDse:
		>=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




=09




                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
		Author: Suhen Pather
		  INET: pathers5_at_telkom.co.za=20

		Fat City Network Services    -- (858) 538-5051  FAX: (858)
538-5051
		San Diego, California        -- Public Internet access /
Mailing
	Lists




=09




                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=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
	Author: Suhen Pather
	  INET: pathers5_at_telkom.co.za=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)=


.

--
Author: Sandeep Kurliye
  INET: Sandeep.Kurliye_at_almarai.com=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


Received on Tue Jul 04 2000 - 10:50:13 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US