oracle clob blob dblink

Create global temporary table temp on commit preserve rows as select * from abc@xxx
 
select * from temp