Oracle Error ORA-01400 and ORA-00001
MayOn 310000PW8U Visits (11125)
Once every couple of months I will hear about our client getting the following Oracle error messages.
If you get one of these errors after restoring from backup or migrating to another server, please rebuild the sequence or Recreate Triggers:
RECREATE and ENABLE the TRIGGER
create or replace TRIGGER WORKPERIOD_T
REBUILD THE ORACLE SEQUENCE
a) Run query: select MAX(
b) Drop the sequence in question:
DROP SEQUENCE LOGINTRACKINGSEQ;
c) Recreate the sequence as the recorded value+1.
create sequence LOGINTRACKINGSEQ start with 111;