Retention Software

[lesstjm]

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?

[irehman]

Why not use OEM and create a Job that fires the trigger ever day.

[sambavan]

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

[Jani]

Please
Write an example of dbms_job or steps for create and use of job in OEM.
Jani