I have an Oracle database, I want to purge any data older than 365 days from all tables.

All the tables in this DB doesn’t have timestamps in them. So I couldn’t develop a SQL based solution.

Oracle logs all transactions occurring in a database.
So I was wondering if there is a setting in Oracle to configure it to purge all records which didn’t change in the last xx days.