Resetting the Oracle Identity Seed/Sequence on a Table
alter table tblname modify identcolumnname generated as identity ( start with 1);
Comments are closed.
alter table tblname modify identcolumnname generated as identity ( start with 1);