Solution : https://service.sap.com/sap/support/notes/449891 (SAP Service marketplace login required)
Key words :
Business Information Warehouse, temporary tables, query processing, DB02, BW, CLEAR_HLP_TBLS, ora-00942, truncate, SQLDBIF_DSQL2_OBJ_UNKNOWN
Related Notes :
| 1165174 | Performance optimization for queries with hierarchies |
| 1139396 | Temporary database objects in BW 7.X |
| 1068324 | Views are not dropped after usage in hierarchy queries |
| 1031929 | Deadlocks at concurrent deletes on the same hierarchy table |
| 1013912 | FAQ: Oracle BW performance |
| 974639 | SAP_DROP_TMPTABLES: Nametab is deleted incompletely |
| 830468 | FAQ: Business Information Warehouse system with SAP MaxDB |
| 755147 | SQL error -3007 when you access DB system tables |
| 706478 | Preventing Basis tables from increasing considerably |
| 648203 | Database objects with INVALID status |
| 514907 | Processing complex queries (data mart, and so on) |
| 308533 | Temporary Database Objects in BW 2.0 |
| 33814 | Warnings of inconsistencies between database & R/3 DDIC |