[Home] [Help] [Dependency Information]
Object Name: | SY_PURG_MST# |
---|---|
Object Type: | VIEW |
Owner: | GMA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PURGE_ID | NUMBER | (5) | Yes | |
PURGE_TYPE | VARCHAR2 | (4) | Yes | |
STATUS | NUMBER | (5) | Yes | |
PURGE_COMMENT | VARCHAR2 | (256) | ||
ROWS_ARCHIVED | NUMBER | (10) | ||
ROWS_DELETED | NUMBER | (10) | ||
ARCHIVE_START_TIME | DATE | |||
ARCHIVE_ELAPSED_TIME | NUMBER | (38) | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
ORA_STATUS | NUMBER | |||
PURGE_START_TIME | DATE | |||
PURGE_ELAPSED_TIME | NUMBER | (38) | ||
TRANS_CNT | NUMBER | (10) | ||
DELETE_MARK | NUMBER | (5) | Yes | |
TEXT_CODE | NUMBER | (10) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
SELECTION_ELAPSED_TIME | NUMBER | (38) | ||
COPY_ELAPSED_TIME | NUMBER | (38) | ||
ROWS_PER_SECOND | NUMBER | (38) | ||
COPY_ROWS_PER_SECOND | NUMBER | (38) | ||
DEBUG_FLAG | VARCHAR2 | (1) | ||
DISABLE_CONSTRAINTS_FLAG | VARCHAR2 | (1) | ||
CALCULATE_STORAGE_FLAG | VARCHAR2 | (1) | ||
COMMIT_FREQUENCY | NUMBER | |||
PURGE_STATUS | NUMBER | (5) | Yes | |
OBJECT_OWNER | VARCHAR2 | (30) | ||
ARCHIVE_TABLE_COUNT | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT PURGE_ID
, PURGE_TYPE
, STATUS
, PURGE_COMMENT
, ROWS_ARCHIVED
, ROWS_DELETED
, ARCHIVE_START_TIME
, ARCHIVE_ELAPSED_TIME
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, ORA_STATUS
, PURGE_START_TIME
, PURGE_ELAPSED_TIME
, TRANS_CNT
, DELETE_MARK
, TEXT_CODE
, LAST_UPDATE_LOGIN
, SELECTION_ELAPSED_TIME
, COPY_ELAPSED_TIME
, ROWS_PER_SECOND
, COPY_ROWS_PER_SECOND
, DEBUG_FLAG
, DISABLE_CONSTRAINTS_FLAG
, CALCULATE_STORAGE_FLAG
, COMMIT_FREQUENCY
, PURGE_STATUS
, OBJECT_OWNER
, ARCHIVE_TABLE_COUNT
FROM GMA.SY_PURG_MST#;
|
|
|