thanks for your immediate response. In the meantime we tried your sequences with the following results (i've tried to translate the german result-messages, with no garantuee on correctness :):
SQL> alter trigger FUDFORUMUSER.FUD30_MSG_STORE_ID_TRG compile;
Warnung: Trigger wurde mit Kompilierungsfehlern geändert.
(Warning: trigger was changed with compiling errors)
SQL> show errors trigger FUDFORUMUSER.FUD30_MSG_STORE_ID_TRG
Fehler bei TRIGGER FUDFORUMUSER.FUD30_MSG_STORE_ID_TRG:
(Error with TRIGGER ...)
LINE/COL ERROR
-------- -----------------------------------------------------------------
1/7 PL/SQL: SQL Statement ignored
1/14 PL/SQL: ORA-02289: Sequence ist nicht vorhanden.
(Sequence does not exist)
While everything fails, our DB-Admin tried to define the missing sequences manually, with
SQL> select object_name, status from user_objects where object_type='TRIGGER' and status='INVALID' order by 1;
OBJECT_NAME STATUS
-------------------------------------------------------------------------------------------------------------------------------- -------
FUD30_FORUM_READ_ID_TRG INVALID
FUD30_MSG_REPORT_ID_TRG INVALID
FUD30_MSG_STORE_ID_TRG INVALID
FUD30_POLL_OPT_ID_TRG INVALID
FUD30_POLL_OPT_TRACK_ID_TRG INVALID
SQL> create sequence fud30_forum_read_id_seq increment by 1 start with 1 nocache nocycle
SQL> create sequence fud30_msg_report_id_seq increment by 1 start with 1 nocache nocycle
SQL> create sequence fud30_msg_store_id_seq increment by 1 start with 1 nocache nocycle
SQL> create sequence fud30_poll_opt_id_seq increment by 1 start with 1 nocache nocycle
SQL> create sequence fud30_poll_opt_track_id_seq increment by 1 start with 1 nocache nocycle
and compiled the invalid triggers again after having done this. But the error occured again, everytime i started the install-procedure again.
Again, thanks for your help, and a merry christmas for you and your family.
Calendar
Search
Help
Members
Register
Login
Home
]