PURGE_ARCHIVE_EXCEPTION
Definition
The PURGE_ARCHIVE_EXCEPTION table contains information about errors occurring during the purge/archive process
Technical Data
| Schema Version | 4.5.2 | |
| Tablespace | BART_DATA | |
| Partitioned | No | |
Summary
The PURGE_ARCHIVE_EXCEPTION table is defined by the following columns in your back-end database. See the column details for more information.
| Name | PK | FK | IX | Uses | Used by | Definition |
|---|---|---|---|---|---|---|
| PROCESS_NAME |
|
The name of the procedure where the error occurred | ||||
| RECORD_DATE |
|
The date when the exception occurred | ||||
| EXCEPTION |
|
The code of the exception returned by the database | ||||
| SQL |
|
The SQL command where the error occurred |
Column Details
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
PROCESS_NAME
| Definition | The name of the procedure where the error occurred |
| Type | VARCHAR(256), NOT NULL |
RECORD_DATE
| Definition | The date when the exception occurred |
| Type | TIMESTAMP, NOT NULL |
EXCEPTION
| Definition | The code of the exception returned by the database |
| Type | VARCHAR(2000), NOT NULL |
SQL
| Definition | The SQL command where the error occurred |
| Type | VARCHAR(4000), NOT NULL |