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


TABLE: SYS.SEQ$

Object Details
Object Name: SEQ$
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
I_SEQ1 NORMAL UNIQUE TablespaceSYSTEM ColumnOBJ#
Columns
Name Datatype Length Mandatory Comments
OBJ# NUMBER
Yes
INCREMENT$ NUMBER
Yes
MINVALUE NUMBER

MAXVALUE NUMBER

CYCLE# NUMBER
Yes
ORDER$ NUMBER
Yes
CACHE NUMBER
Yes
HIGHWATER NUMBER
Yes
AUDIT$ VARCHAR2 (38) Yes
FLAGS NUMBER

PARTCOUNT NUMBER

Query Text

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


SELECT OBJ#
,      INCREMENT$
,      MINVALUE
,      MAXVALUE
,      CYCLE#
,      ORDER$
,      CACHE
,      HIGHWATER
,      AUDIT$
,      FLAGS
,      PARTCOUNT
FROM SYS.SEQ$;

Dependencies

[top of page]

SYS.SEQ$ does not reference any database object

SYS.SEQ$ is referenced by following:

SchemaSYS
ViewALL_SEQUENCES
ViewALL_TAB_IDENTITY_COLS
ViewDBA_OBJ_AUDIT_OPTS
ViewDBA_SEQUENCES
ViewDBA_TAB_IDENTITY_COLS
Package BodyDBMS_METADATA_UTIL - show dependent code
Package BodyDBMS_PLUGTS - show dependent code
ViewEXU7SEQ
ViewEXU8SEQ
ViewKU$_AUDIT_OBJ_BASE_VIEW
ViewKU$_IDCOL_SEQ_VIEW
ViewKU$_SEQUENCE_VIEW
ViewLOGSTDBY_SUPPORT_SEQ
ViewUSER_OBJ_AUDIT_OPTS
ViewUSER_SEQUENCES
ViewUSER_TAB_IDENTITY_COLS