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


TABLE: SYS.CLI_PART$

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

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

LOB_FLAGS NUMBER

NAME VARCHAR2 (128)
PART_SCN NUMBER

PART_TIME DATE

MIN_SCN NUMBER

MIN_TIME DATE

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#
,      PART#
,      TS#
,      LOB_FLAGS
,      NAME
,      PART_SCN
,      PART_TIME
,      MIN_SCN
,      MIN_TIME
,      SPARE1
,      SPARE2
,      SPARE3
,      SPARE4
FROM SYS.CLI_PART$;

Dependencies

[top of page]

SYS.CLI_PART$ does not reference any database object

SYS.CLI_PART$ is referenced by following:

SchemaSYS
ViewDBA_SECUREFILE_LOG_PARTITIONS