Page Comparison

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.
column owner format A45
set linesize 200
set pagesize 5000

spool unsupported_LOB.txt
select owner, table_name, column_name 
from dba_lobs 
where encrypt not in ('NO','NONE')
or compression not in ('NO','NONE')
or deduplication not in ('NO','NONE'
order by owner);
spool off