-
Does anyone know of a software product that can be set up to log into the database and delete old records from the database on a regular schedule. For example, I want records deleted from table a,b, and c that are more then 90 days old. Or I want records deleted out of another database where col1 = ' y' and the record is more then a day old. Is there a software product that can do this automatically?
-
Why not use OEM and create a Job that fires the trigger ever day.
-
Why don't you write a plsql procedure and use the dbms_job package to schedule it. That would be the one way.
The second is write a shell/batch sql script and schedule it using the crontab on unix and at on windows.
Sam
-
Please
Write an example of dbms_job or steps for create and use of job in OEM.
Jani