Which brings me to a reference to a link to the archives of this list: //www.freelists.org/archives/oracle-l/06-2005/msg00782.html A post linking to 'poor man's partitioning' by Lex de Haan, who left this planet(R) at Febr. 1st 2006. It is a year ago, tomorrow. He's missed by many. Regards, Carel-Jan === If you think education is expensive, try ignorance. (Derek Bok) === > Having had good results with partitioning at my last job, that would be > my > preference. Unfortunately, partitioning isn't an option when using > Standard > Edition One as we are. The company isn't yet in a position financially to > pay the licensing fees for an editiion that supports partitioning. This > is > why I'm looking for other options. I still am leaning towards an archive > table in the same database. > > Sandy > > -- //www.freelists.org/webpage/oracle-l