Q: ORA-08103: object no longer exists - DDL on MSC Partition Tables R12.2.4
DDL on MSC Partition Tables can cause of error "ORA-08103: object no longer exists" (not exists for a moment, while being DDL)
Example: 1. HP report in running for get HP report by Category level ( running time : 45 minutes). it's starting: 8:00 AM
2. 'Purge Legacy Data' is starting 8:30 AM (instance legacy: XX1) it's truncate partition XX1. but custom HP report is using MSC… for standard instance: 'S01' not same partition why program end error with
ORA-08103: object no longer exists.
the custom HP reports are end error with ORA-08103: object no longer exists
we don't set incompatibility both all custom HP reports with one program: 'Purge Legacy Data'.