Previous Topic: ORACLE_TABLESPACENext Topic: ORG_UNIT_MGR_NAME (Organizational Unit Manager Name)


ORACLE_TD (Technical Design Oracle Extension)

Column Name

Coltype

Description

MODEL_ID

NUMERIC

ID of the containing model

TBNAME

STRING

ORACLE_TD

ID

NUMERIC

Unique identifier

ORG_ENCY_ID

NUMERIC

Original encyclopedia identifier

ORG_ID

NUMERIC

Original object identifier

OWNER_ID

STRING

Owner identifier

DFLT_DBNAME

STRING

Default DB Name

RI_ENFRCMNT

CHAR

Referential integrity enforcement

RES_WORD_CHK

CHAR

Reserved word check?

DBMS_REL_VER

CHAR

DBMS release version

PV_READ_ENF

CHAR

Permitted value READ enforcement

PV_DBMS_ENF

CHAR

Permitted value DBMS enforcement

DEF_VALUE_ENF

CHAR

Default value enforced?

NULL_OR_DEF

CHAR

Create NULL or default value?

INIT_UNIT_QTY_T

STRING

Unit of initial quantity-tablespace

NXT_UNIT_QTY_T

STRING

Unit of next quantity-tablespace

INIT_SIZE_T

NUMERIC

Initial size of tablespace

NEXT_SIZE_T

NUMERIC

Next size of tablespace

MIN_EXT_T

NUMERIC

Minimum extents for tablespace

MAX_EXT_T

NUMERIC

Maximum extents for tablespace

STG_OFFLINE

STRING

Create storage offline?

PCT_INCR_T

NUMERIC

Percent increase for tablespace

DATAFILE_SZ

NUMERIC

Datafile size

DATAFILE_SZ_UN

STRING

Datafile size unit

DATAFILE_REUSE

CHAR

Reuse datafile?

PCT_FREE_B

NUMERIC

Percent free space for table

PCT_USED_B

NUMERIC

Percent used space for table

INIT_TRANS_B

NUMERIC

Initial number of transactions for table

MAX_TRANS_B

NUMERIC

Maximum number of transactions for table

INIT_UNIT_QTY_B

STRING

Unit of initial quantity for table

NXT_UNIT_QTY_B

STRING

Unit of next quantity for table

MIN_EXT_B

NUMERIC

Minimum extents for table

MAX_EXT_B

NUMERIC

Maximum extents for table

FREE_LSTGR_B

NUMERIC

Groups of free lists for table

FREE_LSTGR_N_B

NUMERIC

Number of list of group freelist for table

INIT_UNIT_QTY_I

STRING

Unit of initial quantity for index

NXT_UNIT_QTY_I

STRING

Unit of next quantity for index

MIN_EXT_I

NUMERIC

Minimum extents for index

MAX_EXT_I

NUMERIC

Maximum extents for index

FREE_LSTGR_N_I

NUMERIC

Number of list of group freelist for index

PCT_FREE_I

NUMERIC

Percent free space for index

INIT_TRANS_I

NUMERIC

Initial number of transactions for index

MAX_TRANS_I

NUMERIC

Maximum number of transactions for index

NOSORT

STRING

No sort?

DATA_BLK_SIZE

NUMERIC

Data block size

TECH_DSN_ID

NUMERIC

Base technical design this object is extended from.

Join with TECHNICAL_DESIGN.