Oracle Designer Model, Release 6i
Deletion rules
Deletion rules on TABLESPACE reference properties, i.e. rule if referenced element is deleted
| Reference Property | Deletion Rule |
| STORAGE_DEFINITION_REFERENCE | Block attempt to delete STORAGE_DEFINITION |
| DATABASE_REFERENCE | Cascade delete, if DATABASE deleted (Owning foreign key) |
Impact on child element types if TABLESPACE is deleted
| Impact on children | Via child reference property |
| Nullify reference on INDEX_PARTITION | INDEX_PARTITION.TABLESPACE_REFERENCE |
| Nullify reference on LOB_STORAGE | LOB_STORAGE.INDEX_TABLESPACE_REFERENCE |
| Nullify reference on LOB_STORAGE | LOB_STORAGE.TABLESPACE_REFERENCE |
| Nullify reference on NESTED_TABLE_STORAGE | NESTED_TABLE_STORAGE.TABLESPACE_REFERENCE |
| Cascade delete DATAFILES | DATAFILE.TABLESPACE_REFERENCE |
| Cascade delete DIAGRAM_ELEMENT_USAGES | DIAGRAM_ELEMENT_USAGE.CIELEMENT_REFERENCE |
| Cascade delete DOCUMENT_ATTACHMENTS | DOCUMENT_ATTACHMENT.ELEMENT_REFERENCE |
| Cascade delete EXTENDED_STRUCTURE_ELEMENTS | EXTENDED_STRUCTURE_ELEMENT.PART_OF_REFERENCE |
| Cascade delete EXTENDED_STRUCTURE_ELEMENTS | EXTENDED_STRUCTURE_ELEMENT.USE_OF_REFERENCE |
| Cascade delete SERVER_OBJECT_USAGES | SERVER_OBJECT_USAGE.CIELEMENT_REFERENCE |
| Block, if CLUSTER_IMPLEMENTATIONS exist | CLUSTER_IMPLEMENTATION.TABLESPACE_REFERENCE |
| Block, if DATABASE_USERS exist | DATABASE_USER.DEFAULT_TABLESPACE_REFERENCE |
| Block, if DATABASE_USERS exist | DATABASE_USER.TEMP_TABLESPACE_REFERENCE |
| Block, if INDEX_STORAGES exist | INDEX_STORAGE.TABLESPACE_REFERENCE |
| Block, if QUEUE_TABLE_IMPLEMENTATIONS exist | QUEUE_TABLE_IMPLEMENTATION.TABLESPACE_REFERENCE |
| Block, if ROLLBACK_SEGMENTS exist | ROLLBACK_SEGMENT.TABLESPACE_REFERENCE |
| Block, if SNAPSHOT_IMPLEMENTATIONS exist | SNAPSHOT_IMPLEMENTATION.TABLESPACE_REFERENCE |
| Block, if TABLESPACE_QUOTAS exist | TABLESPACE_QUOTA.TABLESPACE_REFERENCE |
| Block, if TABLE_IMPLEMENTATIONS exist | TABLE_IMPLEMENTATION.OVERFLOW_TABLESPACE_REFERENCE |
| Block, if TABLE_IMPLEMENTATIONS exist | TABLE_IMPLEMENTATION.SNAP_LOG_TABLESPACE_REFERENCE |
| Block, if TABLE_IMPLEMENTATIONS exist | TABLE_IMPLEMENTATION.TABLESPACE_REFERENCE |
| Block, if TABLE_PARTITIONS exist | TABLE_PARTITION.TABLESPACE_REFERENCE |