|
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. |
|
Copyright © 2013 CA.
All rights reserved.
|
|