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. -- //www.freelists.org/webpage/oracle-l