Exporting Archived Data
After archiving your account balance and journal data, your Database Administrator should export the archive tables from your database to an operating system file.
To export the archive tables:
1. Make sure there is enough disk space for your export file. You will need about 75% of the space you needed for your tables.
2. Use the ORACLE RDBMS export utility to export the archive tables.
3. Make sure that your export was successful and verify that there are no errors. If you continue with the following steps without a successful export, you might lose valuable financial data. All of these conditions MUST be satisfied for a successful export:
- Make sure that an export file has been created in your directory and that the file is not empty.
- Look for normal completion of the export file (the last word of your export file should be 'EXIT').
- Carefully monitor the export process while it is running, and look for error messages.
- Make sure that the number of rows exported (as counted by the export program) is the same as the number of rows that you counted for the range of periods being archived.
- Look for other errors in the log file, such as invalid parameters, errors in the export command line, not enough disk space for the export file, etc. The export process stops whenever it finds an error record.
If there are any errors, correct them and rerun the export.
4. Copy the export file to tape.
Attention: Verify that your backup procedure is successful. If you fail to backup the export file successfully and continue with the next step, you might lose valuable financial data.
5. After successfully completing the previous steps, delete the export file from your directory.
See Also
ORACLE RDBMS Utilities User's Guide
