Previous Topic: ORACLE_INDEX_TBSPNext Topic: ORACLE_TABLESPACE


ORACLE_TABLE

Column Name

Coltype

Description

MODEL_ID

NUMERIC

ID of the containing model

TBNAME

STRING

ORACLE_TABLE

ID

NUMERIC

Unique identifier

ORG_ENCY_ID

NUMERIC

Original encyclopedia identifier

ORG_ID

NUMERIC

Original object identifier

NAME

STRING

Name

RI_TRIG_PRFX

STRING

RI trigger and procedure name prefix

OWNER_ID_EXT

STRING

Owner identifier extension

PV_READ_ENF

CHAR

Permitted value READ enforcement

PV_DBMS_ENF

CHAR

Permitted value DBMS enforcement

PCT_FREE_SPACE

NUMERIC

Percent of free space

PCT_USED_SPACE

NUMERIC

Percent of used space

INIT_TRANS_ENT

NUMERIC

Initial number of transaction entries

MAX_TRANS_ENT

NUMERIC

Maximum number of transaction entries

DFLT_PROPS

CHAR

Use default properties?

INIT_SIZE

NUMERIC

Initial size

INIT_SIZE_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

FREE_LSTGR

NUMERIC

Group free lists

FREE_LSTGR_NUM

NUMERIC

Number of list of group freelist

RECORD_ID

NUMERIC

Base record this object is extended from.

Join with RECORD.