SQL error 1732 when accessing table "PROGDIR".

Category               Installation Errors
Runtime Errors         DBIF_RSQL_SQL_ERROR
Except.                CX_SY_OPEN_SQL_DB
Date and Time          27.08.2015 20:37:59


 Short text
     SQL error 1732 when accessing table "PROGDIR".


 What happened?
     Error Text of the Database: "ORA-01732: data manipulation operation not legal
      on this view"


 What can you do?
     Note which actions and input led to the error.
     For further help in handling the problem, contact your SAP administrator
     .
     You can use the ABAP dump analysis transaction ST22 to view and manage
     termination messages, in particular for long term reference.
     Note which actions and input led to the error.
     For further help in handling the problem, contact your SAP administrator
     .
     You can use the ABAP dump analysis transaction ST22 to view and manage
     termination messages, in particular for long term reference.




Solution

Please reset Oracle parameter _simple_view_merging as it is not needed
at your system.

SQL>alter system reset "_simple_view_merging";

 

SAP note: 1431798 - Oracle 11.2.0: Database Parameter Settings

Thanks

Yoonus