troubleshooting Question

Invalid Oracle views

Avatar of malleka
malleka asked on
Oracle Database
4 Comments1 Solution821 ViewsLast Modified:
We are trying to find the reason why some of the Oracle views become invalid after running a Java application.
The only DDLs the Java application use is to disable/enable indexes on some tables for data loading. There is no schema change on any of the base tables of the views that become invalid.

There is a DDL trigger I am trying to use to get the objects that change while the application is running, as shown in the attachment. For some reason, I cannot get the text of the SQL that causes the change. I would like to know if there is any other way of getting the SQL statement into this ddl_log table.


Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 4 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros