Oracle 将12c标识列序列重置为1

SQL> create table t ( x int generated as identity, y int);

Table created.

SQL>
SQL> insert into t (y) select 10*rownum from dual connect by level <= 10;

10 rows created.

SQL>
SQL> alter table t modify x generated as identity ( minvalue 0 );

Table altered.

SQL>
SQL> alter table t modify x generated as identity ( increment by -10 );

Table altered.

SQL>
SQL> insert into t (y) values ( 1 );

1 row created.

SQL> roll;
Rollback complete.
SQL>
SQL> alter table t modify x generated as identity ( increment by 1);

Table altered.

SQL>
SQL> insert into t (y) values ( 1 );

1 row created.

SQL>
SQL> select * from t;

         X          Y
---------- ----------
         1         10
         2         20
         3         30
         4         40
         5         50
         6         60
         7         70
         8         80
         9         90
        10        100
         1          1