Re: Partition Ideas for Data Archival
From: Steven Andrew <postora_at_gmail.com>
Date: Wed, 26 Jun 2013 14:57:31 -0700
Message-ID: <CAE6QNMvXKihJRUF0DM9KG-HR=Bi5MgXtxrh6omuCsa9Qg0z_-w_at_mail.gmail.com>
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 ?
Date: Wed, 26 Jun 2013 14:57:31 -0700
Message-ID: <CAE6QNMvXKihJRUF0DM9KG-HR=Bi5MgXtxrh6omuCsa9Qg0z_-w_at_mail.gmail.com>
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-lReceived on Wed Jun 26 2013 - 23:57:31 CEST