RE: cannot truncate a table

From: Sandeep Kurliye <Sandeep.Kurliye_at_almarai.com>
Date: Tue, 4 Jul 2000 15:35:18 +0300
Message-Id: <10548.111167@fatcity.com>

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=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
	--------------------------------------------------------------------
	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

	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 Tue Jul 04 2000 - 07:35:18 CDT