Skip common site navigation and headers
United States Environmental Protection Agency
Begin Hierarchical Links EPA Home > Water > Wetlands, Oceans, & Watersheds > Monitoring and Assessing Water Quality > STORET > Data Owner's Corner > System Updates > Referential & Data Integrity Fix RIFIX001 End Hierarchical Links


STORET logo STORET Version 2.0 Referential & Data Integrity Fix - RIFIX001


STORET Referential & Data Integrity Fix RIFIX001 consolidates updates to targeted referential Integrity Issues in STORET, and corrects existing Referential & Data Integrity Issues in the tables. RIFIX001 replaces or modifies a total of 15 tables in STORET. Once you have done this update, you will have incorporated all TARGETED changes made to STORET Referential & Data Integrity Issues from their original release through November 1, 2004.




Download RIFIX001.EXE (62.2 KB) Now

Quit Without Downloading File

Referential & Data Integrity Fix "RIFIX001" will completely update targeted referential integitry issues in your copy of STORET. It will modify the all date fields with years matching the pattern 209? and 009? and correct the year stored to the 20th century 199?.

There are also changes to the Unit of Measure table, and other minor changes.

This download is in the form of a compressed, self-extracting 26.2 KB file, named RIFIX001.EXE. You should place it in a temporary folder, and double-click it to allow it to expand.

In its extracted form, it will consist of a folder, RIFIX001, with subdirectories named "Setup", "Log", "Backup", and "Install" which will contain all files needed for this update. The "Setup" subdirectory will contain files named "Readme.txt" and "setup.bat".

The "Readme.txt" file contains complete instructions for installation of this file following its download. The "Setup.bat" file should be used to automatically install this fix, provided your installation of the STORET is the stand-alone PC version using Personal Oracle ®. If you are running the client/server form of STORET, this upgrade must be performed by your Oracle Data Base Administrator (DBA). Detailed instructions for the DBA to upgrade a client/server copy of STORET are also included in this "Readme.txt" file.

As installation proceeds, three additional subdirectories are utilized. One, named "Log", contains logs of informative, warning, or error messages produced during the installation. In the event of problems, these logs will assist us in our trouble-shooting efforts. A second, named "Backup", contains a backup of your original reference data tables, and scripts which may be used to reload them onto your copy of STORET in the event of problems. The third, named "Install", consists of scripts which are created and/or modified during the installation as necessary.

Installation of this fix takes two to five minutes, once the file has been downloaded and expanded.

To download this file, click the "Download Now" button at your left. To quit without downloading, click the "CANCEL" button.


Need Help? If you have a question, or are uncertain about this download,
please call STORET User Assistance at 1-800-424-9067, or send us an email at


Begin Site Footer

EPA Home | Privacy and Security Notice | Contact Us