This preface contains:
Changes in Oracle Database 12c Release 2 (220.127.116.11)
The following are the changes in Oracle Database Object-Relational Developer's Guide for Oracle Database 12c Release 2 (18.104.22.168).
The following features are new in this release:
Support for PIDL and PCTAS on Varray and ADT Columns. For more information, see the Parallel Queries with Oracle Objects section.
Collation Support for Object Types— A relational column created to store a user-defined type (UDT) attribute inherits the UDT's collation property. As such, an object column can be created under any user-level and table-level collation. However, since all UDTs in Oracle Database 12c release 2 (22.214.171.124) are created using the pseudo-collation
USING_NLS_COMP, relevant columns for the UDT attributes are created with this collation property as well. The only collation allowed is
This section lists the features deprecated in Oracle Database 12c release 2 (126.96.36.199).
REFs to object tables using primary keys as object identifiers. Users must not create REF columns/attributes scoped to or having REFERENCES constraints with any such table. Users must use system-generated object identifiers generated using sys_guid() sql functions for object tables.
NESTED TABLEstored as index-organized table (IOT)
ALTER TYPE … INVALIDATEhas been deprecated. You must use
ALTER TYPE ... CASCADEinstead.
This section lists the features desupported in Oracle Database 12c release 2 (188.8.131.52).
Desupport of Advanced Replication. Multi-master based replication of objects is desupported. Oracle strongly recommends you to use Oracle Logical Standby and Oracle Golden Gate that uses log-based replication. For more information, refer to Replication Support for Objects.