Choose this option to dump audit data. In an audit-enabled database, audit data is stored in multiple tables. When dumping audit data, the Data Dictionary dumps each table into a separate file named with the table name and a .ad extension. To ensure the integrity of the audit data, the Data Dictionary creates a data seal for each dumped file. Each file is part of a set of files that can only be loaded together.
When you select the Audit Data option from the Dump Data and Definitions menu, the Dump Audit Data Filter dialog box appears, and contains the following fields:
Select All — Indicates that all audit data tables will be dumped.
Select Some — Allows you to specify a date range. When you choose Select Some, the Data Dictionary activates the Start Date and End Date fields:
Start Date — Enter the date of the first audit transaction you want to dump. The default entry is the earliest audit transaction stored in the database.
End Date — Enter the date of the last audit transaction you want to dump. The default entry is the most recent audit transaction stored in the database.
After you click OK in the Dump Audit Data Filter dialog box, the Dump Audit Data dialog box appears, and contains the following fields:
Output Directory — The name of the directory into which the Data Dictionary places the dumped files. Leave this field blank to use the current directory. The dumped files are named for the tables from which they are dumped with a .ad extension.
Character Mapping — Specifies the type of character mapping:
Default Map — Leave the Character Mapping field blank to use the default mapping
MAP — Enter the type of character mapping (for example, MAP laserwriter/french or MAP hp2/spanish/italian)
NO MAP — Specifies not to perform any character mapping
Code Page — Indicates that the file will be dumped in the UTF-8 format. You cannot change the code page when dumping audit data.
Note: The user must have Audit Archiver permissions in order to access the Audit Data option. If a user without Audit Archiver permissions selects the Audit Data option, the Data Dictionary creates an error file named _aud-audit-data.e in the dump directory.
If the Data Dictionary encounters an error while validating the file or directory name or when verifying that the database is connected, it places a file named _dmpsec.e in the intended dump directory. If the intended dump directory does not exist, the Data Dictionary places _dmpsec.e in the session's current working directory.
Select All — Indicates that all audit data tables will be dumped.