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


TABLE: SYS.CLI_TAB$

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

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: CLI_TAB$PK
  1. ColumnGUID
  2. ColumnUSER#
  3. ColumnLOG#
  4. ColumnTAB#
Indexes
Index Type Uniqueness Tablespace Column
CLI_TAB$PK NORMAL UNIQUE TablespaceSYSTEM ColumnGUID
ColumnUSER#
ColumnLOG#
ColumnTAB#
Columns
Name Datatype Length Mandatory Comments
GUID VARCHAR2 (32) Yes
USER# NUMBER
Yes
LOG# NUMBER
Yes
TAB# NUMBER
Yes
VER# NUMBER

NAME VARCHAR2 (128)
FLAGS NUMBER

LOB_FLAGS NUMBER

CUR_TS# NUMBER

CRT_SCN NUMBER

CRT_TIME DATE

MIN_SCN NUMBER

MIN_TIME DATE

HIGH_PART# NUMBER

NUM_PARTS NUMBER

SPARE1 NUMBER

SPARE2 NUMBER

SPARE3 NUMBER

SPARE4 NUMBER

Query Text

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


SELECT GUID
,      USER#
,      LOG#
,      TAB#
,      VER#
,      NAME
,      FLAGS
,      LOB_FLAGS
,      CUR_TS#
,      CRT_SCN
,      CRT_TIME
,      MIN_SCN
,      MIN_TIME
,      HIGH_PART#
,      NUM_PARTS
,      SPARE1
,      SPARE2
,      SPARE3
,      SPARE4
FROM SYS.CLI_TAB$;

Dependencies

[top of page]

SYS.CLI_TAB$ does not reference any database object

SYS.CLI_TAB$ is referenced by following:

SchemaSYS
ViewDBA_SECUREFILE_LOG_PARTITIONS
ViewDBA_SECUREFILE_LOG_TABLES