I try to automate deleting logs from Oracle Downstream target database, which are not needed for capture process anymore. The query:
SELECT NAME , PURGEABLE from DBA_REGISTERED_ARCHIVED_LOG;
returns, for example, 10 archive logs. Is it correct to delete older logs, not registered in capture process? Please help to find correct suggestion. Is there any ready solutions for dealing with the old redo-transported logs or I need to write script from scratch?