OraFAQ Forum: SQL & PL/SQL » ORA-04023:Object <trigger name

Home » SQL & PL/SQL » SQL & PL/SQL » ORA-04023:Object <trigger name > could not be validated or authorized

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

ORA-04023:Object <trigger name > could not be validated or authorized [message #560447]

Fri, 13 July 2012 00:31

rishwinger
Messages: 101
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

Littlefoot
Messages: 16967
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.

Report message to a moderator

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

joy_division
Messages: 4266
Registered: February 2005
Location: East Coast USA

Senior Member

Maybe it would help if you showed the code, you think?

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 21 23:39:33 CDT 2013

Total time taken to generate the page: 0.23750 seconds