HI experts,
we have table where a4297735 records from below condition on table J_DOC, we need to delete the records older then 90 days for those status='Pent' .
First we need to store this records into temp table, while creating temp table on below condition database is getting stopped, kindly suggest how can we store into temp table. to delete records older then 90 days and status='Pent' from table J_DOC.'
SELECT count(*)
FROM J_DOC
WHERE LAST_UPDATE_TIME_UTC <= TRUNC(SYSDATE) - 90 and status='Pent';
4297735