oracle clob blob dblink

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

select * from temp