Page Comparison

...

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');