Export
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
Arsene Lupain
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.