Solution : https://service.sap.com/sap/support/notes/2254866 (SAP Service marketplace login required)
Summary :
SAP Note addresses the implementation of Oracle Database 12c features like Automatic Data Optimization (ADO), Information Lifecycle Management (ILMP), and Hybrid Columnar Compression (HCC) with row-level locking in SAP environments based on SAP NetWeaver. Prerequisites include Oracle Database 12c Release 1 Patch Set 1 (12.1.0.2) plus relevant SAP Bundle Patches, correct licensing of the Advanced Compression Option, and minimum SAP NetWeaver 7.40 SP12 for full support. Restrictions include ADO policies only at tablespace level and the inability to enable/disable ADO policies, only allowing creation and deletion. Additional resources are provided through a white paper and SAP Note references.
Key words :
customer component bc-db-ora oracle priority correction, medium priority category release planning information validity, oracle database 12c functionality automatic data optimization, sap environment 2287504 oracle database error ora-39726, oracle database 12c release 1 patch set 1, oracle database sap bundle patch november 2105, r3load based system copy support sap ddic, partitions hybrid columnar compression segment policy, oracle database 12 automatic data optimization, oracle database 12c ado/ilm
Related Notes :
| 2258061 | Enhancements for ADO/ILM for table conversions or system copy with SMIGR_CREATE_DDL |
| 2255992 | R3load and R3szchk: New Oracle feature for database ILM policy. |
| 2254836 | BR*Tools support for Oracle ADO/ILM |
| 2282185 | DBA Cockpit: ADO/ILM monitor |
| 1915316 | Database: Patches for 12.1.0.2 |
| 1914631 | Central Technical Note for Oracle Database 12c Release 1 (12.1) |
| 1888485 | Database Parameter for 12.1.0.2 |
| 1590515 | SAP Software and Oracle Exadata |
| 105047 | Support for Oracle functions in the SAP environment |
| 2287504 | Oracle Database Error ORA-39726 WHEN ADDING OR DROPPING A COLUMN in Oracle 12.1.0.2 after uncompressing a table or partition |
| 2290084 | SAP Software and Oracle Database Appliance Version 12.1 |