Hi to all the Gurus,

I am working on a project with a database that has 5 years worth of data in 300 tables. The Developer/DBA before me, left behind a database that is practically out of space.

I was asked to wack everything and only keep
only 12 tables out of the 300
and 2 years of ONLY RECENT data.

I am thinking to do an export with TABLES= t1, t2,t3,t4,......t12 and INDEX=N as some indexes might be corrupted.

How to go by keep only 2 years of the recent data? Do I export everything and delete from the relevant tables where sysdate <-365

What is the best approach
Thanks in advance