cant drop old partitions - urgent help needed
hi !
after a partial refresh I am trying to drop the old partitions and it worked for one table but not working for the other ,
1) selecting from the partition that i refreshed the data is visible.SQL> select txn_id,ext_date_time from pa_lane_txn PARTITION (LANECURR_JAN_13_DATA) where rownum<4;TXN_ID EXT_DATE_---------- ---------1.2549E+10 31-DEC-121.2549E+10 31-DEC-121.2549E+10 31-DEC-122) count(*) doesnt work as the other partitions are visible in data dictionary SQL> select * from pa_lane_txn;select * from pa_lane_txn*ERROR at line 1:ORA-00376: file 221 cannot be read at this timeORA-01110: data file 221:'+PATRON_DATA/dg_patron/datafile/lanecurr_default.450.788485803' 3) dropping the old partition is not working .SQL> alter table pa_lane_txn drop partition LANECURR_APR_12_DATA;alter table pa_lane_txn drop partition LANECURR_APR_12_DATA*ERROR at line 1:ORA-00604: error occurred at recursive SQL level 1ORA-06502: PL/SQL: numeric or value errorORA-06512: at line 5ORA-00376: file 318 cannot be0