DBA Data[Home] [Help] [Dependency Information]

VIEW: GMA.SY_PURG_MST#

Object Details
Object Name: SY_PURG_MST#
Object Type: VIEW
Owner: GMA
Subobject Name:
Status: VALID

[View Source]

Columns
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

Query Text

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#;

Dependencies

[top of page]

GMA.SY_PURG_MST# references the following:

SchemaGMA
TableSY_PURG_MST
GMA.SY_PURG_MST# is referenced by following:

SchemaAPPS
SynonymSY_PURG_MST