Thank you.

I was able to get the insert into archive tables and delete from base tables to work. I guess it would be better to do it using partitions.

Can I create partitions based on the partial information in the column. (e.g. - substr(column....))

Thanks again
Hedy