Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Trigger error in Oracle8.1.7.0 on HP UNIX

SOLVED
Go to solution
KVS Raju
Advisor

Trigger error in Oracle8.1.7.0 on HP UNIX

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.





Time and Tide wait for none
2 REPLIES
Christian Gebhardt
Honored Contributor
Solution

Re: Trigger error in Oracle8.1.7.0 on HP UNIX

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
Exalted Contributor

Re: Trigger error in Oracle8.1.7.0 on HP UNIX

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com