Solution : https://service.sap.com/sap/support/notes/721332 (SAP Service marketplace login required)
Key words :
terms rollup aggregate parallel ora-1652 psaptemp temporary table star_transformation merge join cartesian ora-1436 reason, merge join cartesian command, merge join cartesian, temp table transformation plan, temporary table, temp table transformation, table access full, ora-1652 error, ora-1436 error, select / + parallel
Related Notes :
| 755629 | KKO merge fix for Oracle 9.2.0.5 |
| 727310 | Wrong Results with ODS or Non-Star_Transformation Queries |
| 721331 | 9204: MERGE JOIN CARTESIAN IN TEMP TABLE- STAR and FACT 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 |