Hi,
Oracle 11gR2.
I have a large table in my database that I need to purge every month so the idea is to store the data by months.
the large table is "T" and I create a table by mounths: T_JAN, T_FEB, T_MAR..... that will filed by trigger based on table T (before insert).
It make sens if I create the table T as "GLOBAL TEMPORARY TABLE" or it's better to add a 'DELETE' on the trigger ?
NB: I need to keeb data just intablme T_JAN, T_FEB... not in T.
Best regards,