Re: Archive Strategies

From: Alan Johns <Alan_at_tarragon.co.uk>
Date: Thu, 11 Mar 1999 11:27:00 +0000
Message-ID: <ctjj0AAEi652gAwu@tarragon.co.uk>

There is a tool from Princeton Softech called Move for Servers. While in essence it is a relational data extract and insertion tool, it can also provide a relational archiving function for Oracle data as well.

If this sounds interesting, please call me at the below number.

Thanks.
In article <7c443k$rk1_at_world1.bellatlantic.net>, Douglas Whitacre <whitacre_at_imake.com> writes
>Does anyone have any high level implementation strategies on Archiving? Are
>there any tools out there that handle Archiving? The only strategy that
>I've seen implemented with Archiving is:
>
>1. Have a duplicate set of tables in another account (or with the prefix
>ARC - Like ARC_EMPLOYEES)
>2. Copy records to be archived to the duplicate or ARC tables
>3. Export the duplicate or ARC tables
>4. Verify the Export was successful
>5. Delete the rows in the regular table based on the keys from the ARC
>tables
>6. Delete the rows in the ARC tables and wait for the next archive.
>
>
>

Best regards
--
Alan Johns
Tarragon Software Ltd - UK & Ireland Distributor for

        Princeton Softech's -   Upgrade 2000
                                Ager 2000
                                Relational Tools for DB2
                                Move for Servers - Oracle
                                Version Merger
        
        ELISE - the MatchMaker. Software for recruitment, estate agencies,      
                                dating agencies, etc from WCC

Phone: 44(0)1480 414141
Fax: 44(0)1480 436869 Received on Thu Mar 11 1999 - 05:27:00 CST