Oracle Designer Model, Release 6i
Deletion rules
Deletion rules on STORAGE_DEFINITION reference properties, i.e. rule if referenced element is deleted
| Reference Property | Deletion Rule |
Impact on child element types if STORAGE_DEFINITION is deleted
| Impact on children | Via child reference property |
| Nullify reference on INDEX_PARTITION | INDEX_PARTITION.STORAGE_DEFINITION_REFERENCE |
| Nullify reference on LOB_STORAGE | LOB_STORAGE.INDEX_STORAGE_DEFN_REFERENCE |
| Nullify reference on LOB_STORAGE | LOB_STORAGE.STORAGE_DEFINITION_REFERENCE |
| Nullify reference on NESTED_TABLE_STORAGE | NESTED_TABLE_STORAGE.STORAGE_DEFINITION_REFERENCE |
| Nullify reference on TABLE_PARTITION | TABLE_PARTITION.STORAGE_DEFINITION_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 FOLDER_MEMBERS | FOLDER_MEMBER.MEMBER_OBJECT |
| Cascade delete SET_MEMBER_ITEMS | SET_MEMBER_ITEM.ELEMENT_REFERENCE |
| Block, if CLUSTER_IMPLEMENTATIONS exist | CLUSTER_IMPLEMENTATION.STORAGE_DEFINITION_REFERENCE |
| Block, if INDEX_STORAGES exist | INDEX_STORAGE.STORAGE_DEFINITION_REFERENCE |
| Block, if QUEUE_TABLE_IMPLEMENTATIONS exist | QUEUE_TABLE_IMPLEMENTATION.STORAGE_DEFINITION_REFERENCE |
| Block, if ROLLBACK_SEGMENTS exist | ROLLBACK_SEGMENT.STORAGE_DEFINITION_REFERENCE |
| Block, if SNAPSHOT_IMPLEMENTATIONS exist | SNAPSHOT_IMPLEMENTATION.STORAGE_DEFINITION_REFERENCE |
| Block, if TABLESPACES exist | TABLESPACE.STORAGE_DEFINITION_REFERENCE |
| Block, if TABLE_IMPLEMENTATIONS exist | TABLE_IMPLEMENTATION.SNAP_LOG_STORAGE_REFERENCE |
| Block, if TABLE_IMPLEMENTATIONS exist | TABLE_IMPLEMENTATION.STORAGE_DEFINITION_REFERENCE |