eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: GMA.SY_PURG_MST#

Source

View Text - Preformatted


select PURGE_ID PURGE_ID, PURGE_TYPE PURGE_TYPE, STATUS STATUS, PURGE_COMMENT PURGE_COMMENT, ROWS_ARCHIVED ROWS_ARCHIVED, ROWS_DELETED ROWS_DELETED, ARCHIVE_START_TIME ARCHIVE_START_TIME, ARCHIVE_ELAPSED_TIME ARCHIVE_ELAPSED_TIME, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, ORA_STATUS ORA_STATUS, PURGE_START_TIME PURGE_START_TIME, PURGE_ELAPSED_TIME PURGE_ELAPSED_TIME, TRANS_CNT TRANS_CNT, DELETE_MARK DELETE_MARK, TEXT_CODE TEXT_CODE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, SELECTION_ELAPSED_TIME SELECTION_ELAPSED_TIME, COPY_ELAPSED_TIME COPY_ELAPSED_TIME, ROWS_PER_SECOND ROWS_PER_SECOND, COPY_ROWS_PER_SECOND COPY_ROWS_PER_SECOND, DEBUG_FLAG DEBUG_FLAG, DISABLE_CONSTRAINTS_FLAG DISABLE_CONSTRAINTS_FLAG, CALCULATE_STORAGE_FLAG CALCULATE_STORAGE_FLAG, COMMIT_FREQUENCY COMMIT_FREQUENCY, PURGE_STATUS PURGE_STATUS, OBJECT_OWNER OBJECT_OWNER, ARCHIVE_TABLE_COUNT ARCHIVE_TABLE_COUNT from "GMA"."SY_PURG_MST"

View Text - HTML Formatted

SELECT PURGE_ID PURGE_ID
, PURGE_TYPE PURGE_TYPE
, STATUS STATUS
, PURGE_COMMENT PURGE_COMMENT
, ROWS_ARCHIVED ROWS_ARCHIVED
, ROWS_DELETED ROWS_DELETED
, ARCHIVE_START_TIME ARCHIVE_START_TIME
, ARCHIVE_ELAPSED_TIME ARCHIVE_ELAPSED_TIME
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, ORA_STATUS ORA_STATUS
, PURGE_START_TIME PURGE_START_TIME
, PURGE_ELAPSED_TIME PURGE_ELAPSED_TIME
, TRANS_CNT TRANS_CNT
, DELETE_MARK DELETE_MARK
, TEXT_CODE TEXT_CODE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SELECTION_ELAPSED_TIME SELECTION_ELAPSED_TIME
, COPY_ELAPSED_TIME COPY_ELAPSED_TIME
, ROWS_PER_SECOND ROWS_PER_SECOND
, COPY_ROWS_PER_SECOND COPY_ROWS_PER_SECOND
, DEBUG_FLAG DEBUG_FLAG
, DISABLE_CONSTRAINTS_FLAG DISABLE_CONSTRAINTS_FLAG
, CALCULATE_STORAGE_FLAG CALCULATE_STORAGE_FLAG
, COMMIT_FREQUENCY COMMIT_FREQUENCY
, PURGE_STATUS PURGE_STATUS
, OBJECT_OWNER OBJECT_OWNER
, ARCHIVE_TABLE_COUNT ARCHIVE_TABLE_COUNT
FROM "GMA"."SY_PURG_MST"