Solution : https://service.sap.com/sap/support/notes/669247 (SAP Service marketplace login required)
Key words :
explain plan set statement_id = 'plan_table'forselect / + star_transformation fact, prior loop execution plan st04 st05 rsrt reason, sql scripts $oracle_ome/rdbms/admin/utlxpls, sqland $oracle_home/rdbms/admin/utlxplp, sap support packages & patches-> sap web, terms ora-1436 ora-01436 star_transformation_enabled temp_disable 9, 20 -> support packages -> sap basis 6, prior id = parent_id start, sqlan abap code change, ora-01436 oracle error occurs
Related Notes :
| 755629 | KKO merge fix for Oracle 9.2.0.5 |
| 721332 | 9204: MJC in temporary table causes ORA-1652 (PARALLEL hint) |
| 721331 | 9204: MERGE JOIN CARTESIAN IN TEMP TABLE- STAR and FACT Hint |