Upon upgrading Stat and running the upgrade script UORAvxxx-xxx.sql, the error below is raised:
Possibly the suggested trigger STAT_DBSCRIPT_TBL_TRG1 is disabled (INVALID) in your database.
The value for ID column is generated by sequence and insert by the trigger. Your sequence start value will be different than my.
CREATE OR REPLACE TRIGGER STAT.STAT_DBSCRIPT_TBL_TRG1
BEFORE INSERT
ON STAT.STAT_DBSCRIPT_TBL
FOR EACH ROW
BEGIN
SELECT STAT.stat_dbscript_tbl_seq.NEXTVAL
INTO :NEW.id
FROM DUAL;
END stat_dbscript_tbl_trg1;
/
CREATE SEQUENCE STAT.STAT_DBSCRIPT_TBL_SEQ
START WITH 85
MAXVALUE 999999999999999999999999999
MINVALUE 1
NOCYCLE
NOCACHE
NOORDER;
Solution:
1. Please check if the database has these two objects (needs to be enabled/valid):
2. Please, enable (compile) trigger STAT_DBSCRIPT_TBL_TRG1 since this is not a custom defined trigger. It is part of the Stat installation. Then re-run the upgrade script as schema STAT to verify in TOAD or SQL.
