Solution : https://service.sap.com/sap/support/notes/1677201 (SAP Service marketplace login required)
Summary :
When a tablespace with objects enabled for deferred segment creation is dropped without specifying "INCLUDING CONTENTS," it leads to corrupt dictionary data issues. This causes errors such as ORA-00604 and ORA-00959 when trying to access objects within the non-existent tablespace. Oracle bug 13326736 addresses this issue and patch fixes are scheduled in various SAP Bundle Patches for UNIX and Windows systems post-March 2012. Organizations should use the "INCLUDING CONTENTS AND DATAFILES" clause to avoid such problems and consider restoration from backups if faced with these errors prior to patch application.
Key words :
sap bundle patches / oracle patch collections, effectively leaves corrupt dictionary information, exist sql> drop table test, drop tablespace test2 including contents, sql> drop table test, recursive sql level 1 ora-00959, deferred segment creation enabled, drop table test, sap customer message, existing dictionary inconsistencies
Related Notes :
| 1631931 | Oracle 11.2.0: Patches / Patch collections for 11.2.0.3 |
| 1583303 | Deferred Segment Creation |
| 1503709 | Oracle 11.2.0: Patches / Patch collections for 11.2.0.2 |