EXECUTE_CATALOG_ROLE
CREATE ANY TABLE
ALTER ANY TABLE
DROP ANY TABLE
LOCK ANY TABLE
SELECT ANY TABLE
CREATE ANY TRIGGER
CREATE ANY INDEX

declare
  nr_errors    pls_integer;
  v_tab        varchar2(60);
  v_tab_iterim varchar2(60);
  v_owner      varchar2(60);
begin
  v_tab        := 'TEST_TAB'; 
  v_tab_iterim := 'TEST_TAB_TEMP'; 
  v_owner      := 'SCHEMA'; 
  
  dbms_redefinition.abort_redef_table(uname => v_owner, orig_table => v_tab, int_table    => v_tab_iterim);
  dbms_redefinition.can_redef_table  (uname => v_owner, tname      => v_tab, options_flag => dbms_redefinition.cons_use_pk);
  dbms_redefinition.start_redef_table(uname        => v_owner,
                                      orig_table   => v_tab,
                                      int_table    => v_tab_iterim,
                                      options_flag => dbms_redefinition.cons_use_pk);
  dbms_redefinition.copy_table_dependents(uname            => v_owner, 
                                          orig_table       => v_tab,
                                          int_table        => v_tab_iterim,
                                          copy_indexes     => 1,
                                          copy_triggers    => true,
                                          copy_constraints => true,
                                          copy_privileges  => true,
                                          ignore_errors    => true,
                                          num_errors       => nr_errors,
                                          copy_statistics  => true);
  dbms_redefinition.sync_interim_table(uname => v_owner, orig_table => v_tab, int_table => v_tab_iterim);
  dbms_redefinition.finish_redef_table(uname => v_owner, orig_table => v_tab, int_table => v_tab_iterim);  
end;
/

set role all;