The following functionality is currently not supported, but maybe supported in future:
- XMLType.
- 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 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'); |