coexistence of global and partitioned indexes
Hello!
in my case there are global and partitioned indexes on some table, full version number of oracle database is 11.2.0.4.0
Could you explain please,
in what chronological sequence
- did blockings occur (and released) and take place actions during removing (synchronous removing and adding) of the partition ;
- did removing partition and entries of global index ;
- what of this processes can prevent dml-activity ?
in othwer words how this ddl-operations (and deleting entries from global index ) affects dml-activity ?
what occurs earlier - deleting entries from global index or deleting of partition ?
if deleting entries from global index is the last step in the chain then subsequent dml-activity is possible directly after ddl ?