select max(pk_column_id) from table;

alter sequence <owner>.<sequence_name> increment by <max_pk_val - current_val>

CREATE OR REPLACE PROCEDURE SYS.P_SYNCHRONIZE_SEQUENCES (schema_owner dba_users.username%TYPE default 'SCOTT') AS
 v_max_val  number default null;
 v_next_val number default null;
 v_count    number default 0;
BEGIN
 for the_tables in 
 (select c.table_name as table_name, c.owner as owner, i.column_name as column_name, c.table_name||'_SQ' as sequence_name
  from dba_constraints c, dba_ind_columns i
 where c.index_name = i.index_name AND c.owner = schema_owner AND c.constraint_type = 'P')
 loop
  execute immediate 'select max('||the_tables.column_name||') from ' || the_tables.table_name INTO v_max_val;

  if v_max_val < 1 then
  v_max_val := 1;
  end if;
  
  execute immediate 'select '||the_tables.owner||'.'||the_tables.sequence_name||'.nextval from dual' INTO v_next_val;

  if v_next_val < v_max_val then
   v_next_val := (v_max_val - v_next_val);
   execute immediate 'alter sequence '||the_tables.owner||'.'||the_tables.sequence_name||' increment by '||v_next_val;
   v_count := v_count + 1;
  end if;
   
 end loop;
 
  dbms_output.put_line('Synchronized '||v_count||' sequences for schema owner: '||schema_owner);
  
EXCEPTION
   WHEN OTHERS THEN
      raise_application_error(-20001,'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM);
 
END;
/