Hello all --
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
I am trying to truncate a partition from tab table with range partition on date data type column.
ALTER TABLE DM.SUMMARY TRUNCATE PARTITION PTYR09Q1;
and I am getting following error
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
The table is there and I can able to select, insert, update, delete from the table *DM.SUMMARY*
Any help would be greatly appreciated.
Thanks,