The following functionality is currently not supported, but maybe supported in future:
...
- Table cluster related DDL.
- IOTs (index-organized tables - coming in November 2012).
- Switchover/failover/flashback.
- Object datatypes (includes ADT, VARRAY, nested tables etc.).
- SDO_GEOMETRY datatype.
- Only English version is available. Different languages will be supported in the future.
- No support for compression or encrypted data (Transparent Data Encryption TDE).
...
- No support for encrypted data (Transparent Data Encryption TDE).
- No support for compressed data.
- External tables
- Nested tables
NOLOGGING - if it is not in the redo, it's not replicated.
LOBs with CTAS (create table as select) or direct insert (that's e.g. the APPEND hint, or sqlldr with direct=yes)
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'); |