CREATE GLOBAL TEMPORARY TABLE comments ON COMMIT PRESERVE ROWS 
    AS SELECT * FROM oper@uv4;
select * 
    from comments;

select id
    from oper@uv4

select id,big_date_clob
    from oper@uv4

удалённые операции над таблицами объектов и столбцами пользовательских типов не разрешены

create table oper (
FIELD_V$ TDATA#VARRAYOBJ, 
big_date_clobCLOB, 
id number
)

create global temporary table t_clob 
       as SELECT --FIELD_VALUES$, 
                 SYSTEM_DATA, 
                 operation_id 
              FROM operation@uibdev4;
select * 
    from t_clob;

drop table t_clob;

on commit preserve rows

update table ss
set ss.body= (select body from table@DBLINK sss where id=ss.id) where id =123 ;

update table ss
set ss.body= (select body from table@DBLINK sss where id=ss.id) where id =123 ;