Support for the first release will be limited to the Lake environment.
The following features are currently not supported for Managed OTF operations:
- Volatile tables
- Space management
- Primary/Foreign key
- QUEUE tables
- APPEND tables
- PERMANENT JOURNAL
- Time series tables
- UAF
- Temporal tables
- Load Utilities
- TPT Load operator (Fastload)
- TPT Update operator (Mload/MloadX)
- TPT Stream operator (Tpump)
TPT Inserter operator (Singleton insert) is supported in the current release.
Key Limitations and Restrictions for Managed OTF Tables
- STJI with ROWID is not supported when the DML mode is set to copy-on-write.
- DML operations through views on MOTF tables are not supported.
- ALTER TABLE restrictions apply as follows:
- Same limitations as OFS tables.
- Additionally, ALTER TABLE REORGANIZE is not supported on MOR tables.
- Soft Referential Integrity (RI) is supported during table creation; however, Hard RI is not.
- DROP DATALAKE is disallowed if any managed table is linked to the datalake.
- DELETE DATABASE is not permitted if the database contains any managed OTF tables.
- For MOTF UPI, the columns defined in SORTED BY or PARTITIONED BY must match or be a subset of the UPI columns. Otherwise, Failure 5712 will occur.
- MSR is not supported.
- Triggers are not allowed.
- BTET and ANSI transactions are not supported.