Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Table cluster related DDL.
  • Switchover/failover/flashback.
  • No support for encrypted data (Transparent Data Encryption TDE).
  • No support for compressed data. 
  • External tables
  • Nested tables 
  • NOLOGGING hint - This operation does not put the data in the redo log so it is therefore not logged.

  • APPEND hint- This operation does not put the data in the redo log so it is therefore not logged.

  • Sqlloader with direct option- This operation does not put the data in the redo log so it is therefore not logged.

  • LOBs with CTAS (create table as select) 

  • Deferrable Constraints *** when target database is not Oracle
  • Online Table Move (12.2 feature)
  • Proxy Pluggable Database
  • Application Containers and Application Container Pluggable Databases

The following script will check to see if the tables are clustered:

...