Re: Can someone point me to a link?

Scott wrote:
> I want to Archive data, that is to move the data once all my
> operations are done with few tables to a list of Archive tables.
> That is I need to move data from a list of selected tables to Archive
> tables on a periodic basis.
> Can some one point me to the best practices in ORACLE to achieve this
> in a Production Environment?
>
> Thank you for all help. This is one of the best forums with experienced
> professionals.
>
> Scott.

What Oracle version?

My first thought is Materialized Views but your have not provided sufficient information to be sure that they will do what you want?

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)