[Home] [Help] [Dependency Information]
Object Name: | DAM_CLEANUP_JOBS$ |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Purge Jobs configured for the Audit Trail Types
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_C00236373 | NORMAL | UNIQUE | SYSTEM | JOB_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
JOB_NAME | VARCHAR2 | (100) | Yes | Name to identify the Purge Job |
JOB_STATUS | NUMBER | Status of the Purge Job | ||
AUDIT_TRAIL_TYPE# | NUMBER | Yes | The Audit Trail Type for which Last Archive Timestamp is set | |
JOB_INTERVAL | NUMBER | Yes | Time between the Purge Job runs | |
JOB_FREQUENCY | VARCHAR2 | (100) | The repeat interval of the Purge Job | |
JOB_FLAGS | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT JOB_NAME
, JOB_STATUS
, AUDIT_TRAIL_TYPE#
, JOB_INTERVAL
, JOB_FREQUENCY
, JOB_FLAGS
FROM SYS.DAM_CLEANUP_JOBS$;
SYS.DAM_CLEANUP_JOBS$ does not reference any database object
SYS.DAM_CLEANUP_JOBS$ is referenced by following:
|
|
|