comenglish的专栏

原文出处：https://community.oracle.com/message/4016489#4016489   Dont't recreate the sequence! You would invalidate all independent objects and lose all privileges granted for the sequences.Instead try...

Instead try this: SQL>CREATE SEQUENCE SEQ_TEST   2   START WITH  1   3   INCREMENT BY  1   4   MINVALUE  1   5   MAXVALUE  9999999; Sequence created. SQL> SQL>SELECT SEQ_TEST.NEXTVAL   2    FROM all_objects WHERE ROWNUM &a