DBA_XDS_LATEST_ACL_REFSTAT
The DBA_XDS_LATEST_ACL_REFSTAT data dictionary view displays all latest static ACL refresh job status history that has been done in the database. It has the same schema as DBA_XDS_ACL_REFSTAT dictionary view, but a subset of its rows.
Related Views
| Column | Datatype | NULL | Description |
|---|---|---|---|
SCHEMA_NAME |
VARCHAR2(128) |
NOT NULL |
Name of schema |
TABLE_NAME |
VARCHAR2(128) |
NOT NULL |
Name of table |
REFRESH_MODE |
VARCHAR2(9) |
ON COMMIT, SCHEDULED, or ON DEMAND |
|
REFRESH_ABILITY |
VARCHAR2(11) |
COMPLETE or INCREMENTAL |
|
JOB_START_TIME |
TIMESTAMP(6) WITH TIME ZONE |
The refreshment job starting time | |
JOB_END_TIME |
TIMESTAMP(6) WITH TIME ZONE |
The refreshment job ending time | |
ROW_UPDATE_COUNT |
NUMBER |
Number of rows have been updated for static ACL sync | |
STATUS |
NUMBER |
Refreshment job status: 0 means success, otherwise an error number is displayed. |
|
ERROR_MESSAGE |
VARCHAR2(4000) |
The error message for the error, if there is any. |