Lets say you have one row in
your table, with ID = 1. Someone decides they need to have a
record with ID = 10, and so they insert using
insert into table (id) values (10)
.
You now have a ticking timebomb -
the sequence will continue to increment 2, 3 etc, until it
reaches 10 at which time the insert fails with
ERROR at line 1:
ORA-00001: unique constraint (SYS.SYS_C002948) violated
Conversely, a trigger method would
overwrite a value from an explicit ID value using a value specified
in the sequence instead.
Many users experience ORA-00001.
Upon truncating MTL_REVISIONS_INTERFACE will
take care of ORA-00001 by using the instructions below:
- Create table backup_<tarno> as select * from MTL_REVISIONS_INTERFACE
- Truncate table MTL_REVISIONS_INTERFACE
- Resubmit item for item import