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.

I dont't know what you are after, but EMC has a product called Database Extender which basically consist of delete triggers, a scheduler,
a dabase Link to an archive Database, union views over archive and prod tables and a fancy GUI. I Assume an average DBA could implement that in a few days (without the GUI of course).

regards

s.kapitza Received on Tue Nov 01 2005 - 02:47:56 CST