ALL_XDS_LATEST_ACL_REFSTAT
The ALL_XDS_LATEST_ACL_REFSTAT data dictionary view displays all latest static ACL refresh job status history that has been done for tables that are accessible to the application user. It has the same schema as ALL_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. |