Database DataWarehousing (MOSC)

MOSC Banner

ORA-00942 on ALTER TABLE TRUNCATE PARTITION

edited Jan 14, 2010 1:38AM in Database DataWarehousing (MOSC) 8 commentsAnswered ✓
I'm trying to truncate a partition as the schema owner using the following syntax:

alter table schema.TABLE_NAME truncate partition PARTION_NAME reuse storage;

I get the following messages in reply:

ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist

The database level is 10.2.0.4

I did a search on metalink but nothing was found.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center