RE: cannot truncate a table

From: Sandeep Kurliye <Sandeep.Kurliye_at_almarai.com>
Date: Tue, 4 Jul 2000 18:05:59 +0300
Message-Id: <10548.111174@fatcity.com>

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

	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

Received on Tue Jul 04 2000 - 10:05:59 CDT