Trigger error in Oracle8.1.7.0 on HP UNIX

[KVS Raju]

Hi,

we are facing a problem on triggers in Oracle 8.1.7.0 on HP unix.
While doing following operations. The table name is not properly updating in 'description' column of 'all_triggers' table. This causing problem while exporting and inporting the data.

1) Create a table 'test'

2) Create a one trigger 'T_test' on 'test' table

3) Create a synonym on 'test'
i.e. create synonym 'sys_test;
4) Drop a synonym the synonym 'sys_test'
i.e. drop synonym 'sys_test'
5) Now rename the table 'test'
with 'sys_test'
i.e. rename test to sys_test
6) And again rename the table 'sys_test' to 'test'

After the above operation, if you check the trigger 'descritpion' the table name is not properly updating in the
'BEFORE INSERT OR UPDTAE ' statement.

[Christian Gebhardt · Accepted solution]

Hi

looks like Bug No. 2097405
which is fixed in Oracle 9.2

I've tested it on 8.1.7.4 and the same result.

So I think: no chance :-(

Chris

[Steven E. Protter]

You may have some objects you need to recompile.

Check your oracle structure for invalid objects.

There actually is a one off patch that might help you. Its listed in one of my back Oracle problem posts in this forum.

SEP