PUB_AUTHOR.SYS_C0013175 |
TableName | PUB_AUTHOR |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PUB_AUTHOR.SYS_C0013175 Index Columns |
ColumnName | Sort Order |
PUB_ID | Ascending |
LAST_NAME | Ascending |
RANK | Ascending |
PUB_AUTHOR.SYS_C0013175 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | PUBL |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
PUB_AUTHOR.SYS_C0013175 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PUB_AUTHOR.SYS_C0013175 Bound Attachments |
Name | Current Value |
PUB_BEAMLINE.SYS_C0013174 |
TableName | PUB_BEAMLINE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PUB_BEAMLINE.SYS_C0013174 Index Columns |
ColumnName | Sort Order |
PUB_ID | Ascending |
BEAMLINE | Ascending |
PUB_BEAMLINE.SYS_C0013174 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | PUBL |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
PUB_BEAMLINE.SYS_C0013174 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PUB_BEAMLINE.SYS_C0013174 Bound Attachments |
Name | Current Value |
PUB_BEAMLINE_INFO.SYS_C0013170 |
TableName | PUB_BEAMLINE_INFO |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PUB_BEAMLINE_INFO.SYS_C0013170 Index Columns |
ColumnName | Sort Order |
BEAMLINE | Ascending |
PUB_BEAMLINE_INFO.SYS_C0013170 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | PUBL |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
PUB_BEAMLINE_INFO.SYS_C0013170 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PUB_BEAMLINE_INFO.SYS_C0013170 Bound Attachments |
Name | Current Value |
PUB_JOURNAL_ARTICLE.SYS_C0013172 |
TableName | PUB_JOURNAL_ARTICLE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PUB_JOURNAL_ARTICLE.SYS_C0013172 Index Columns |
ColumnName | Sort Order |
ID | Ascending |
PUB_JOURNAL_ARTICLE.SYS_C0013172 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | PUBL |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
PUB_JOURNAL_ARTICLE.SYS_C0013172 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PUB_JOURNAL_ARTICLE.SYS_C0013172 Bound Attachments |
Name | Current Value |
PUB_LOG.SYS_C0013168 |
TableName | PUB_LOG |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PUB_LOG.SYS_C0013168 Index Columns |
ColumnName | Sort Order |
ID | Ascending |
PUB_LOG.SYS_C0013168 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | PUBL |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
PUB_LOG.SYS_C0013168 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PUB_LOG.SYS_C0013168 Bound Attachments |
Name | Current Value |
PUB_QUEUE.SYS_C0013176 |
TableName | PUB_QUEUE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PUB_QUEUE.SYS_C0013176 Index Columns |
ColumnName | Sort Order |
ID | Ascending |
PUB_QUEUE.SYS_C0013176 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | PUBL |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
PUB_QUEUE.SYS_C0013176 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PUB_QUEUE.SYS_C0013176 Bound Attachments |
Name | Current Value |
PUB_SCIENTIFIC_DISCIPLINE.SYS_C0013171 |
TableName | PUB_SCIENTIFIC_DISCIPLINE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PUB_SCIENTIFIC_DISCIPLINE.SYS_C0013171 Index Columns |
ColumnName | Sort Order |
ID | Ascending |
PUB_SCIENTIFIC_DISCIPLINE.SYS_C0013171 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | PUBL |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
PUB_SCIENTIFIC_DISCIPLINE.SYS_C0013171 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PUB_SCIENTIFIC_DISCIPLINE.SYS_C0013171 Bound Attachments |
Name | Current Value |
PUB_SESSION.SYS_C0013169 |
TableName | PUB_SESSION |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PUB_SESSION.SYS_C0013169 Index Columns |
ColumnName | Sort Order |
ID | Ascending |
PUB_SESSION.SYS_C0013169 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | PUBL |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
PUB_SESSION.SYS_C0013169 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PUB_SESSION.SYS_C0013169 Bound Attachments |
Name | Current Value |
PUBLICATION.SYS_C0013173 |
TableName | PUBLICATION |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PUBLICATION.SYS_C0013173 Index Columns |
ColumnName | Sort Order |
ID | Ascending |
PUBLICATION.SYS_C0013173 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | PUBL |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
PUBLICATION.SYS_C0013173 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PUBLICATION.SYS_C0013173 Bound Attachments |
Name | Current Value |