The following functionality is currently not supported, but maybe supported in future:
- XMLType.
- Table cluster related DDL.
- IOTs (index-organized tables).
- Switchover/failover/flashback.
- Non-standard redo log block size (including 4k on 11gR2 on Advanced Format disks).
- Object datatypes (includes ADT, VARRAY, nested tables etc.).
- Only English version is available. Different languages will be supported in the future.No support for encrypted data (Transparent Data Encryption TDE).
- No support for compressed data.
- External tables
- Nested tables
- Multitenant Databases (PDB) in 12c
The following script will check to see if the tables are clustered:
No Format |
---|
|
Prompt Specify owner for the tables that you want to replicate
Prompt Specify table_name(s) for the tables that you want to replicate. % for all.
select owner, table_name, cluster_name, iot_name, iot_type
from sys.dba_tables
where (cluster_name is not null
and owner = upper('&owner')
and table_name like upper('&table_name'); |