The following functionality is currently not supported:
- 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 - These operations
LOBs with CTAS (create table as select)
APPEND hint-
Sqlloader with direct option
The following script will check to see if the tables are clustered:
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');