During compilation of view I got the following error:
Warning: View created with compilation errors.
Show err gives No Errors.
SQL> SQL> show err
No errors.
With the following select statement it is possible to find the error:
select text from dba_errors where name = '[OBJECT_NAME]' and owner = '[OBJECT_OWNER]';
Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.
Tuesday, May 19, 2009
Subscribe to:
Post Comments (Atom)
![[Valid Atom 1.0]](http://4.bp.blogspot.com/_1DZkSxdocDo/SeRZqmezMfI/AAAAAAAAAI4/fkoNVB7dsv0/s400/valid-atom.png "Validate my Atom 1.0 feed")
Posts
That's because show errors only shows the *last* error.
ReplyDeleteCheers.
You can also use SQL> show error view :view_name to see errors related to a particular view.
ReplyDeleteyes helped me - thanks
ReplyDeleteGreat stuff, thanks. Saved me from bothering our senior ^^
ReplyDeletedanku vel!!
ReplyDeleteJust the trick I needed - a hell of a lot easier than tracking down a legacy version of EMC.
ReplyDeletemine is more complicated than that. I have two scripts linked by a UNION statement. Previous version worked OK but after making a change in one of the steps I get this %^&* error message. Obviously, some thing is rotten in the linkages but darned if I can find it.
ReplyDeleteVery helpful! Thanks!
ReplyDeleteI tried this but it failed since I am not a DBA and have no access to DBA_ERRORS. But when I simplified it to:
ReplyDeleteselect text from user_errors where name = 'object_name';
It worked. Thanks for putting me on the right track.
A tip I found on OTN was to NOT use FORCE keyword. I did that and the CREATE statement showed the error that led me to a solution.
ReplyDeleteomiting d use of FORCE keywork @least till d compilation is d better option, given an inside view of ver exactly d developer made d mistake.
DeleteAnd this really did helped me.
Helped me quickly. Thanks 1
ReplyDeleteHelp me! Thanks!
ReplyDeleteSaved me a lot of time, Thanks!!
ReplyDeleteThanks a Lot, was very helpfull and saved the valuable time....
ReplyDeleteThank you!! All I was getting was compliation errors and show error said no errors but the query showed me the problem. This was a great tip!! Nick
ReplyDeleteI have DBA privileges
ReplyDeleteQuery did not show me any errors
SHOW ERROR also did not show me any errors
Removing FORCE key work actually showed me error
ReplyDeleteSQL> SHOW ERROR TRIGGER trigger_name
Good tip, worked for me.
ReplyDeleteExcelent!!
ReplyDeleteselect * from user_errors;
ReplyDeleteIt also helps a lot.
Thanks for the info Arjan :)
ReplyDeleteIt helped me
ReplyDeleteExcellent. Thanks. All earlier options didn't show the error. Only after removing 'FORCE' error got displayed.
ReplyDeleteThanks man! this info helped me to resolve the issue.. :)
ReplyDeleteThank you..it helped me... :)
ReplyDeleteThanks dude, Able to find the cause...
ReplyDeletevery nice blogs!!! i have to learning for lot of information for this sites...Sharing for wonderful information. Thanks for sharing this valuable information to our vision. You have posted a trust worthy blog keep sharing
ReplyDeleteDigital Marketing In Telugu
Digital Marketing In Hyderabad
internet marketing
Digital marketing
Digital Marketing Strategy
Hello, I wish for to subscribe for this webpage to get hottest updates, so where can i do it please help.
ReplyDeleteNice
ReplyDeleteLaundroway services in Hyderabad
"Looking to kickstart your career in SAP EWM? Bangalore offers a plethora of options for SAP EWM training.
ReplyDeleteHere’s what to consider:
SAP EWM Training in Bangalore at SAP Masters
1.Quality Training:
Opt for best institutes with a solid reputation and accreditation from SAP Masters Training institute.
Look for expert faculty who can provide comprehensive insights.
2.Curriculum:Ensure the curriculum covers core EWM concepts and offers hands-on projects for practical learning.
3.Infrastructure: Check for modern facilities and labs equipped with the latest software to support your training needs.
4.Placement Support: Choose institutes that offer robust placement assistance, including resume building and interview preparation.
Consider institutes like SAP Masters Institute of Technology, sap masters Academy, and sapmasters training institute bangalore,
known for their quality training and successful placements. Choose wisely, and jumpstart your SAP EWM journey in Bangalore!
Visit SAP Masters - Best SAP Training in Bangalore"
Visit SAP Masters - SAP EWM Training in Bangalore"