Please read PART-I and II
20. External data in the SAP database
o Must be covered by an acquired database license (Note 581312).
o Permitted for administration tools and monitoring tools.
o In addition, we do not recommend to use an SAP database with non-SAP software, since this constellation has considerable disadvantages:
- A database upgrade required for the system can only be performed if all software components that use the database can handle the new release.
- Required changes to database parameters for a system result in a downtime of several systems.
- Required import of database patches for a system result in a downtime of several systems.
- Special SAP database parameter settings may be unsuitable for external software access.
- Conflicts with CPU resources, memory resources, I/O resources and Oracle internal resources.
- Conflicts with BR*TOOLS
- Dependencies and unnecessary downtimes for restore scenarios and recovery scenarios
- The code page must be the same for all systems.
- Critical Oracle bugs, such as the problem described in Note 1107700, are possible.
21. Flashback database (Oracle 10g or higher)
o Can be used (Note 966117).
22. Function-based indexes
o Can be used, but no SAP support is provided.
o No support is provided by SAP-DDIC or by monitoring transactions.
23. Index Organized Tables (IOTs)
o Can be used.
o For more information and details on restrictions, see Note 641435.
24. Intermedia
o You can use this feature in connection with BugsEye / Requisite.
o There is no further SAP support (see Note 740897).
25. Compression
o You can only use table compression in the cases described in Note 701235.
o You can use index compression in accordance with Note 1109743.
26. Materialized Views
o Can be used.
o For more information, see Note 741478.
27. MOVE
o This is supported by BRSPACE as of Release 7.00 (28) or 7.10 (4)(see Note 1080376).
o You can use ALTER TABLE MOVE, but no SAP support is provided if problems and follow-on errors occur (Note 541538).
28. Objects Option
o Cannot be used (Note 740897).
29. OLAP
o Cannot be used (Note 740897).
30. OCFS (Oracle Cluster File System)
o Cannot be used in the RAC environment as described in Note 527843.
Thanks & regards
Rajnikanth