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

TABLE: PJI.PJI_PA_PROJ_EVENTS_LOG_T

Object Details
Object Name: PJI_PA_PROJ_EVENTS_LOG_T
Object Type: TABLE
Owner: PJI
Subobject Name:
Status: VALID

This table is used to take a snapshot of online events.

Temporary Table Details

PJI.PJI_PA_PROJ_EVENTS_LOG_T is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
WORKER_ID NUMBER
Yes Partitioning column.
LOG_ROWID ROWID (10)
Rowid of equivalent row in PA_PJI_PROJECT_EVENTS_LOG
EVENT_TYPE VARCHAR2 (30)
Identifier of the event type
EVENT_ID NUMBER

Unique event identifier
EVENT_OBJECT VARCHAR2 (240)
Identifier of the object of the event
OPERATION_TYPE VARCHAR2 (1)
Operation Type (I, U, D)
STATUS VARCHAR2 (15)
Event Status
LAST_UPDATE_DATE DATE

Standard who column
LAST_UPDATED_BY NUMBER

Standard who column
CREATION_DATE DATE

Standard who column
CREATED_BY NUMBER

Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Event Attribute Category
ATTRIBUTE1 VARCHAR2 (150)
Event Attribute 1
ATTRIBUTE2 VARCHAR2 (150)
Event Attribute 2
ATTRIBUTE3 VARCHAR2 (150)
Event Attribute 3
ATTRIBUTE4 VARCHAR2 (150)
Event Attribute 4
ATTRIBUTE5 VARCHAR2 (150)
Event Attribute 5
ATTRIBUTE6 VARCHAR2 (150)
Event Attribute 6
ATTRIBUTE7 VARCHAR2 (150)
Event Attribute 7
ATTRIBUTE8 VARCHAR2 (150)
Event Attribute 8
ATTRIBUTE9 VARCHAR2 (150)
Event Attribute 9
ATTRIBUTE10 VARCHAR2 (150)
Event Attribute 10
ATTRIBUTE11 VARCHAR2 (150)
Event Attribute 11
ATTRIBUTE12 VARCHAR2 (150)
Event Attribute 12
ATTRIBUTE13 VARCHAR2 (150)
Event Attribute 13
ATTRIBUTE14 VARCHAR2 (150)
Event Attribute 14
ATTRIBUTE15 VARCHAR2 (150)
Event Attribute 15
ATTRIBUTE16 VARCHAR2 (150)
Event Attribute 16
ATTRIBUTE17 VARCHAR2 (150)
Event Attribute 17
ATTRIBUTE18 VARCHAR2 (150)
Event Attribute 18
ATTRIBUTE19 VARCHAR2 (150)
Event Attribute 19
ATTRIBUTE20 VARCHAR2 (150)
Event Attribute 20
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT WORKER_ID
,      LOG_ROWID
,      EVENT_TYPE
,      EVENT_ID
,      EVENT_OBJECT
,      OPERATION_TYPE
,      STATUS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
FROM PJI.PJI_PA_PROJ_EVENTS_LOG_T;

Dependencies

[top of page]

PJI.PJI_PA_PROJ_EVENTS_LOG_T does not reference any database object

PJI.PJI_PA_PROJ_EVENTS_LOG_T is referenced by following:

SchemaAPPS
SynonymPJI_PA_PROJ_EVENTS_LOG_T