Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Table cluster related DDL.
  • Switchover/failover/flashback.
  • No support for encrypted data (Transparent Data Encryption TDE).
  • No support for compressed data. 

The following script will check to see if the tables are clustered:

Section
Column
width5%

 

Column
width95
Panel
bgColorCCC
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');