Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
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