Solution : https://service.sap.com/sap/support/notes/857973 (SAP Service marketplace login required)
Key words :
create table <table>_tmp [nologging] [parallel <degree>] asselect / + index, time consuming index maintenance step, alter table <table>_tmp rename, intensive database operations contained, alter table <table> modify, drop table <table>_tmp, general oracle database problem, sap parallel processing, drop table <table>, truncate table <table>
Related Notes :
| 806554 | FAQ: I/O-intensive database operations |
| 619188 | FAQ: Oracle wait events |
| 618868 | FAQ: Oracle performance |
| 541311 | CC-INFO: Parallel processes FAQ |
| 489690 | CC INFO: Copying large production clients |
| 365304 | CC-ADMIN: Reports for deleting tables |