create or replace procedure table_replace(v_scheme_from in varchar2
                                         ,v_scheme_to   in varchar2
                                         ,v_table_from  in varchar2) as
begin
  dbms_output.put_line(lower(replace(replace(dbms_metadata.get_ddl(object_type => 'TABLE',
                                                                   name        => v_table_from,
                                                                   schema      => v_scheme_from),
                                             v_scheme_from,
                                             v_scheme_to),
                             '"',
                             '')));
  dbms_output.put_line(lower(replace(replace(dbms_metadata.get_dependent_ddl(object_type        => 'TRIGGER',
                                                                             base_object_name   => v_table_from,
                                                                             base_object_schema => v_scheme_from),
                                             '"',
                                             ''),
                                     v_scheme_from,
                                     v_scheme_to)));
end;

create or replace editionable trigger v_scheme_to.rbi_bb_task_trg --само название триггера поменялось, но
  before insert on v_scheme_from.bb_task_tbl --название таблицы нет!
  for each row
begin
  if inserting and
     :new.id_task is null
  then
    select ***.nextval
      into :new.id_task
      from dual;
  end if;
end;