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


TABLE: SYS.CLI_INST$

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

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

MAX_BUCKET# NUMBER

NUM_BUCKETS NUMBER

INC_SCN NUMBER

INC_TIME DATE

CRT_SCN NUMBER

CRT_TIME DATE

INC# 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#
,      INST#
,      FLAGS
,      MAX_BUCKET#
,      NUM_BUCKETS
,      INC_SCN
,      INC_TIME
,      CRT_SCN
,      CRT_TIME
,      INC#
,      SPARE1
,      SPARE2
,      SPARE3
,      SPARE4
FROM SYS.CLI_INST$;

Dependencies

[top of page]

SYS.CLI_INST$ does not reference any database object

SYS.CLI_INST$ is referenced by following:

SchemaSYS
ViewDBA_SECUREFILE_LOG_INSTANCES