Previous Topic: ORACLE_INDEX (Index Oracle Extension)Next Topic: ORACLE_INDEX_TBSP


ORACLE_INDEXSPACE (Indexspace Oracle Extension)

Column Name

Coltype

Description

MODEL_ID

NUMERIC

ID of the containing model

TBNAME

STRING

ORACLE_INDEXSPACE

ID

NUMERIC

Unique identifier

ORG_ENCY_ID

NUMERIC

Original encyclopedia identifier

ORG_ID

NUMERIC

Original object identifier

NAME

STRING

Name

INIT_SIZE

NUMERIC

Initial size

INIT_UNIT

STRING

Unit of initial size

NEXT_SIZE

NUMERIC

Next size

NEXT_UNIT

STRING

Unit of next size

MIN_EXT

NUMERIC

Minimum extents

MAX_EXT

NUMERIC

Maximum extents

PCT_INCREASE

NUMERIC

Percent of increase

PCT_FREE_SPACE

NUMERIC

Percent of free space

INIT_TRAN_ENT

NUMERIC

Initial number of transaction entries

MAX_TRAN_ENT

NUMERIC

Maximum number of transaction entries

NOSORT

STRING

No sort?

NUM_LISTGRP_FR

NUMERIC

Number of lists of group freelist

INDEXSPACE_ID

NUMERIC

Base indexspace this object is extended from.

Join with DATA_STORE_INDEX.