| TABSPACE |
Tablespace Name for ORACLE |
ORATSPNAME |
TSORA
|
CHAR |
|
30 |
0 |
|
| INIT |
Size of an initial ORACLE extent in KB |
ORAINIT |
|
NUMC |
|
10 |
0 |
|
| NEXT |
Size of an ORACLE next extent in KB |
ORANEXT |
|
NUMC |
|
10 |
0 |
|
| MINEXT |
Minimum number of ORACLE extents |
ORAMINEXT |
|
NUMC |
|
10 |
0 |
Possible values
| 0000000001 |
Value range of the extent |
| 0000000501 |
Enhanced Value Range for Extents |
|
| MAXEXT |
Maximum number of ORACLE extents |
ORAMAXEXT |
|
NUMC |
|
10 |
0 |
Possible values
| 0000000001 |
Value range of the extent |
| 0000000501 |
Enhanced Value Range for Extents |
|
| PCTINC |
PCTincrease - parameters |
PCTINC |
|
NUMC |
|
4 |
0 |
|
| OFREELIST |
DD: Number of free storage lists per group |
OFREELISTS |
|
NUMC |
|
3 |
0 |
|
| OFREEGROUP |
DD: Number of groups of free lists |
OFREEGROUP |
|
NUMC |
|
2 |
0 |
|
| OPCTFREE |
DD: Reserved storage area for updates |
OPCTFREE |
|
NUMC |
|
2 |
0 |
Possible values
|
| OPCTUSED |
DD: Lower limit for assignment of data blocks |
OPCTUSED |
|
NUMC |
|
2 |
0 |
Possible values
|
| INITRANS |
|
|
|
NUMC |
|
3 |
0 |
|
| INDEXORG |
Flag if table has structure INDEX ORGANISATION |
INDEXORG |
|
CHAR |
|
1 |
0 |
Possible values
|
| PARTBY |
Partition category |
PARTBY |
|
CHAR |
|
12 |
0 |
Possible values
| NULL |
No partitioning |
| RANGE |
Partitioning with value range specification |
|
| SUBPARTBY |
Subpartitioning (Oracle 10) |
SUBPARTBY |
|
CHAR |
|
12 |
0 |
Possible values
| NULL |
No Subpartitioning |
| RANGE |
Subpartitioning RANGE |
| LIST |
Subpartitioning LIST |
| HASH |
Subpartitioning HASH |
|
| DEFAULT |
Database default |
DBSSTORDEF |
|
CHAR |
|
1 |
0 |
|
| COMPR_CLAUSE |
Oracle Compression Definition (as of Oracle 11) |
ORACOMPRESS |
|
CHAR |
|
40 |
0 |
|
