Oracle重置自增主键Sequence

1.源库查询当前Sequence，
SELECT 'Alter Sequence '|| SEQUENCE_NAME ||

’ Increment By ’ || to_char(LAST_NUMBER +

1000)||‘;’ from user_SEQUENCES;

2.结果更新到新库，并执行以下SQL的结果
SELECT 'select '|| SEQUENCE_NAME ||

‘.nextval from dual;’ from user_SEQUENCES;

3.恢复新库的Increment重置为1
SELECT 'Alter Sequence '|| SEQUENCE_NAME ||

’ Increment By 1;’ from user_SEQUENCES;