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 Managed File Transfer 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.