I am creating an Oracle table with an index column that is auto generated. It works great, and my id column is auto generated starting at the number 1.
After I truncate the table it does not reset the auto increment back to 1. What sql command will reset my auto increment value back to 1 after truncation?
Example of how I create the table :
CREATE TABLE temp (id INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1), BRGS VARCHAR2(36));