Home » SQL & PL/SQL » SQL & PL/SQL » ORA-04023:Object <trigger name > could not be validated or authorized
ORA-04023:Object <trigger name > could not be validated or authorized [message #560447] Fri, 13 July 2012 00:31 Go to next message
rishwinger
Messages: 132
Registered: November 2011
Senior Member
Hi All,

We are adding a column to a table using online redefintion,so its dependent triggers are getting Invalidated.
Table has 3 simple triggers on it
1)Delete trigger-AFTER EACH ROW-Its insert old deleted data in some other table
2)Insert trigger-AFTER EACH ROW-Its insert newly inserted data in some other table
3)Update trigger-AFTER EACH ROW-Its insert updated data in some other table

Modified table might be under some transcation

ISSUE

After recompiling 2 triggers(Insert and Updated) they are compiled successfully but Delete trigger is erroring out with ORA-04023:Object <trigger name > could not be validated or authorized

Q1) Why only delete trigger is errored out?
Q2) How can it be resolved?

Thanks in advance and please let me know if you need some other info

[Updated on: Fri, 13 July 2012 00:45]

Report message to a moderator

Re: ORA-04023:Object <trigger name > could not be validated or authorized [message #560448 is a reply to message #560447] Fri, 13 July 2012 00:38 Go to previous messageGo to next message
Littlefoot
Messages: 19476
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This is what Oracle says:
Quote:

ORA-04023: Object stringstringstringstringstring could not be validated or authorized

Cause: A number of attempts were made to validate or authorize an object but failed.

Action: Please report this error to Oracle Support Services.
Re: ORA-04023:Object <trigger name > could not be validated or authorized [message #560475 is a reply to message #560447] Fri, 13 July 2012 08:19 Go to previous message
joy_division
Messages: 4504
Registered: February 2005
Location: East Coast USA
Senior Member
Maybe it would help if you showed the code, you think?
Previous Topic: SFTP via PL/SQL
Next Topic: Do we have a function in oracle to select not null columns at the begining and null columns later.
Goto Forum:
  


Current Time: Sat Aug 23 02:33:02 CDT 2014

Total time taken to generate the page: 0.11054 seconds