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

TABLE: SYS.INDREBUILD$

Object Details
Object Name: INDREBUILD$
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_INDREBUILD1 NORMAL UNIQUE TablespaceSYSTEM ColumnOBJ#
Columns
Name Datatype Length Mandatory Comments
OBJ# NUMBER
Yes
DATAOBJ# NUMBER

TS# NUMBER
Yes
FILE# NUMBER
Yes
BLOCK# NUMBER
Yes
PCTFREE$ NUMBER
Yes
INITRANS NUMBER
Yes
MAXTRANS NUMBER
Yes
COMPCOLS NUMBER

FLAGS NUMBER

Query Text

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


SELECT OBJ#
,      DATAOBJ#
,      TS#
,      FILE#
,      BLOCK#
,      PCTFREE$
,      INITRANS
,      MAXTRANS
,      COMPCOLS
,      FLAGS
FROM SYS.INDREBUILD$;

Dependencies

[top of page]

SYS.INDREBUILD$ does not reference any database object

SYS.INDREBUILD$ is not referenced by any database object