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

TABLE: SYS.FGA_LOG$FOR_EXPORT_TBL

Object Details
Object Name: FGA_LOG$FOR_EXPORT_TBL
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
SYS_IL0000599409C00013$$ LOB UNIQUE TablespaceSYSTEM
SYS_IL0000599409C00027$$ LOB UNIQUE TablespaceSYSTEM
Columns
Name Datatype Length Mandatory Comments
SESSIONID NUMBER
Yes
TIMESTAMP# DATE

DBUID VARCHAR2 (30)
OSUID VARCHAR2 (255)
OSHST VARCHAR2 (128)
CLIENTID VARCHAR2 (64)
EXTID VARCHAR2 (4000)
OBJ$SCHEMA VARCHAR2 (30)
OBJ$NAME VARCHAR2 (128)
POLICYNAME VARCHAR2 (30)
SCN NUMBER

SQLTEXT VARCHAR2 (4000)
LSQLTEXT CLOB (4000)
SQLBIND VARCHAR2 (4000)
COMMENT$TEXT VARCHAR2 (4000)
STMT_TYPE NUMBER

NTIMESTAMP# TIMESTAMP(6) (11)
PROXY$SID NUMBER

USER$GUID VARCHAR2 (32)
INSTANCE# NUMBER

PROCESS# VARCHAR2 (16)
XID RAW (8)
AUDITID VARCHAR2 (64)
STATEMENT NUMBER

ENTRYID NUMBER

DBID NUMBER

LSQLBIND CLOB (4000)
OBJ$EDITION VARCHAR2 (30)
Query Text

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


SELECT SESSIONID
,      TIMESTAMP#
,      DBUID
,      OSUID
,      OSHST
,      CLIENTID
,      EXTID
,      OBJ$SCHEMA
,      OBJ$NAME
,      POLICYNAME
,      SCN
,      SQLTEXT
,      LSQLTEXT
,      SQLBIND
,      COMMENT$TEXT
,      STMT_TYPE
,      NTIMESTAMP#
,      PROXY$SID
,      USER$GUID
,      INSTANCE#
,      PROCESS#
,      XID
,      AUDITID
,      STATEMENT
,      ENTRYID
,      DBID
,      LSQLBIND
,      OBJ$EDITION
FROM SYS.FGA_LOG$FOR_EXPORT_TBL;

Dependencies

[top of page]

SYS.FGA_LOG$FOR_EXPORT_TBL does not reference any database object

SYS.FGA_LOG$FOR_EXPORT_TBL is not referenced by any database object