I wanted to export 3 tables from db1 into db2.

Before the export starts, I will create the sequences for those 3 tables.

CREATE SEQUENCE TEST_SEQ START WITH 1 INCREMENT BY 1;

After the export, I will reinitialize sequnce values to match the max(id) + 1 from the table.

CREATE OR REPLACE PROCEDURE "TEST_SEQUENCE"
AUTHID CURRENT_USER
is
v_num number;
begin
select max(ID)  into v_num from TABLE_1;
EXECUTE IMMEDIATE 'ALTER SEQUENCE TEST_SEQ  INCREMENT BY ' || v_num;
EXECUTE IMMEDIATE 'ALTER SEQUENCE 1TEST_SEQ  INCREMENT BY 1'; 
end;
/
show errors;
execute TEST_SEQ;

This procedure compiles and executes without problems.

But when I want to check t he last value of the sequence, like select TEST_SEQ.nextval from dual;

I still get the "1".

Can someone tell me why my procedure did not impact my sequence? ps. I am using oracle sql developper to pass sql.

Thanks