Re: Partition Ideas for Data Archival
From: Dba DBA <oracledbaquestions_at_gmail.com>
Date: Tue, 2 Jul 2013 11:03:10 -0400
Message-ID: <CAE-dsOJb3XQUE4m8hcLAMsweyd0Xnh1AhJS=cfBAMc=FD0cD3Q_at_mail.gmail.com>
Do you even need to be this fancy? can't you figure out how much EPOCH time represents 1 month?
Then partition by month using intervals(based on what a month is in EPOCH time)
Have a pl/sql procedure that 'archives' any partition over 6 months. Just use logic to convert this. run it once a month.
Date: Tue, 2 Jul 2013 11:03:10 -0400
Message-ID: <CAE-dsOJb3XQUE4m8hcLAMsweyd0Xnh1AhJS=cfBAMc=FD0cD3Q_at_mail.gmail.com>
Do you even need to be this fancy? can't you figure out how much EPOCH time represents 1 month?
Then partition by month using intervals(based on what a month is in EPOCH time)
Have a pl/sql procedure that 'archives' any partition over 6 months. Just use logic to convert this. run it once a month.
sounds like its taking a calculator and figure out how many mili-seconds represent 1 month and that is your interval value.
I have not use virtual partitions. if you use local indexes, do you need to lead all your local indexes with the virtual partitioned field?
On Wed, Jun 26, 2013 at 5:57 PM, Steven Andrew <postora_at_gmail.com> wrote:
> Thanks Don. Virtual column seems to be good option and we might also
> consider using Ref partitioning along with it, to archive data off of child
> table(s).
> Has anyone implemented Ref Partitioning using virtual column as the
> partitioning key ?
>
> Thanks
> Steven.
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jul 02 2013 - 17:03:10 CEST