Solution : https://service.sap.com/sap/support/notes/572302 (SAP Service marketplace login required)
Key words : 
attached advance correction corrects, symptom deleting requests, ora-01653 ora-12801 reason, terms delete request, longer deletion time, provide advance information, drop partition command, bw support packages, import support package 08, aggregates receiving requests
Related Notes : 
       
| 523240 | SAPBWNews BW 3.0B Support Package 08 |