Solution : https://service.sap.com/sap/support/notes/721331 (SAP Service marketplace login required)
Key words :
terms temp table temporary merge join cartesian mjc psaptemp ora-01652 ora-1436 reason, psaptemp temporary tablespace, merge join cartesian, temp table transformation, temp table generation, ora-1436 errors, table access full, temporary table, extremely long time, sap bw system
Related Notes :
| 755629 | KKO merge fix for Oracle 9.2.0.5 |
| 727310 | Wrong Results with ODS or Non-Star_Transformation Queries |
| 721332 | 9204: MJC in temporary table causes ORA-1652 (PARALLEL hint) |
| 695080 | Merge fix for Oracle 9.2.0.4 |
| 669247 | ORA-1436 in ST04/RSRT/ST05 with Release 9.2 and TEMP table |
| 539921 | Current patch set for Oracle 9.2.0 |
| 354080 | Note collection for Oracle performance problems |