Help, How should I ARCHIVE???

• Quoting Miscrxc_at_Unocal.Com to All dated 03-11-94 ***
  > Please provide any pro's/con's of these methods.
  

The essential difference between your two methods hinges upon exporting/loading ASCII files, or exporting/importing .DMP files... Either of these is reasonable, although the exporting/importing of .DMP files requires less work on your part, is less prone to error, and will provide better performance. However, I recommend some amendments to your scenario:

Have a MAIN and ARCHIVE table; in queries requiring archived data to be included, use a union statement to seamlessly integrate it. While this may not be an option for other reasons, it provides a very clean way to integrate your archived data without requiring that you combine and separate it repeatedly. This also allows you to clean out the unneeded archived data with a DROP TABLE statement, which is a lot quicker than DELETE ... because it does not require rollback segments. If you use the EXPORT method, the table will be recreated when you import, and you needn't worry about loading it directly into MAIN.

Michael Stowe
Director of Technical Services
Constellation Engineering Received on Wed Mar 16 1994 - 22:52:01 CET