Partition Ideas for Data Archival
From: Steven Andrew <postora_at_gmail.com>
Date: Mon, 24 Jun 2013 13:11:00 -0700
Message-ID: <CAE6QNMs1pPFFtDsqMLqY__TDbap9Su6Q1G+8MrKWXT42+0TSpA_at_mail.gmail.com>
Looking for some ideas around archiving 2 tables that we have, seem to be growing too fast than we had expected.
Below are the 2 tables with columns of interest listed.
Date: Mon, 24 Jun 2013 13:11:00 -0700
Message-ID: <CAE6QNMs1pPFFtDsqMLqY__TDbap9Su6Q1G+8MrKWXT42+0TSpA_at_mail.gmail.com>
Looking for some ideas around archiving 2 tables that we have, seem to be growing too fast than we had expected.
Below are the 2 tables with columns of interest listed.
event -- ev_id, ev_time, other cols
event_dtls -- ev_id, other cols
I wish we had ev_time to be date or timestamp data type, unfortunately it's NUMBER with date/time stored in Milli-Seconds since epoch, for e.g. 1372091857723 translates to 6/24/2013 18:37:37.
We want to archive events older than 6 months from both tables, however the ev_time stored in milli-seconds make it challenging.
Any ideas would be appreciated.
Thanks
Steven.
11gR2, 3Node RAC Cluster, Linux 5.8x
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jun 24 2013 - 22:11:00 CEST