You might receive the following error message when updating
your database schema to the latest level by using the ftelog_tables_oracle_702_703.sql file: ERROR
at line 1: ORA-02289: sequence does not exist. This error
occurs because the sequences and triggers used by the tables are not
in the same schema as the tables.
About this task
To fix this problem, you must edit the contents of the
ftelog_tables_oracle_702_703.sql before
running it.
Procedure
- Find out which schema the sequences and triggers used by
the WebSphere® MQ
File Transfer Edition database logger
tables are located in.
- On DB2®, you can use
the Control Center to view the tables and schema.
- On Oracle, you can use the Enterprise Manager to view the
tables and schema.
- Open the ftelog_tables_oracle_702_703.sql file
in a text editor.
- In each occurrence of the text SELECT FTELOG.sequence_name.nextval replace
the text FTELOG with the name of the schema where
your existing sequences are located.
- Before each occurrence of the text CREATE OR REPLACE
TRIGGER FTELOG.trigger_name, insert the
text DROP TRIGGER schema_name.trigger_name,
where schema_name is the name
of the schema where your existing triggers are located.
- Use the edited ftelog_tables_oracle_702_703.sql file
to update the database tables.