Tuesday, May 19, 2009

Warning: View created with compilation errors.

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.
on Tuesday, May 19, 2009 Labels:

31 comments:

  1. AnonymousMay 19, 2009 at 11:02 PM

    That's because show errors only shows the *last* error.

    Cheers.

    ReplyDelete
  2. AnonymousMay 19, 2009 at 11:16 PM

    You can also use SQL> show error view :view_name to see errors related to a particular view.

    ReplyDelete
  3. AnonymousMay 28, 2009 at 11:24 AM

    yes helped me - thanks

    ReplyDelete
  4. AnonymousJune 3, 2009 at 7:43 PM

    Great stuff, thanks. Saved me from bothering our senior ^^

    ReplyDelete
  5. chowJune 17, 2009 at 2:25 PM

    danku vel!!

    ReplyDelete
  6. AnonymousJuly 16, 2009 at 6:13 PM

    Just the trick I needed - a hell of a lot easier than tracking down a legacy version of EMC.

    ReplyDelete
  7. frank greeneSeptember 29, 2009 at 4:03 PM

    mine 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.

    ReplyDelete
  8. AnonymousOctober 18, 2009 at 1:29 AM

    Very helpful! Thanks!

    ReplyDelete
  9. AnonymousFebruary 22, 2010 at 4:45 PM

    I tried this but it failed since I am not a DBA and have no access to DBA_ERRORS. But when I simplified it to:

    select text from user_errors where name = 'object_name';

    It worked. Thanks for putting me on the right track.

    ReplyDelete
  10. AnonymousSeptember 23, 2010 at 1:08 AM

    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.

    ReplyDelete
    Replies
    1. AnonymousOctober 25, 2012 at 11:18 AM

      omiting 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.

      And this really did helped me.

      Delete
  11. AnonymousMarch 24, 2011 at 8:05 AM

    Helped me quickly. Thanks 1

    ReplyDelete
  12. VitorApril 26, 2011 at 5:28 PM

    Help me! Thanks!

    ReplyDelete
  13. AnonymousOctober 19, 2011 at 9:54 PM

    Saved me a lot of time, Thanks!!

    ReplyDelete
  14. krishnaNovember 16, 2011 at 8:30 PM

    Thanks a Lot, was very helpfull and saved the valuable time....

    ReplyDelete
  15. AnonymousDecember 14, 2012 at 7:04 PM

    Thank 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

    ReplyDelete
  16. AnonymousMarch 14, 2013 at 8:36 PM

    I have DBA privileges
    Query did not show me any errors
    SHOW ERROR also did not show me any errors
    Removing FORCE key work actually showed me error

    ReplyDelete
  17. Tariq aliJune 4, 2013 at 8:39 PM


    SQL> SHOW ERROR TRIGGER trigger_name

    ReplyDelete
  18. AnonymousOctober 24, 2013 at 11:14 AM

    Good tip, worked for me.

    ReplyDelete
  19. Me canse de decir luego lo escriboOctober 25, 2013 at 4:10 PM

    Excelent!!

    ReplyDelete
  20. AnonymousNovember 11, 2013 at 10:02 AM

    select * from user_errors;

    It also helps a lot.

    ReplyDelete
  21. AnonymousMarch 24, 2015 at 7:07 AM

    Thanks for the info Arjan :)

    ReplyDelete
  22. UnknownNovember 11, 2015 at 9:37 PM

    It helped me

    ReplyDelete
  23. rbkDecember 11, 2015 at 2:48 PM

    Excellent. Thanks. All earlier options didn't show the error. Only after removing 'FORCE' error got displayed.

    ReplyDelete
  24. AnonymousNovember 8, 2016 at 1:29 PM

    Thanks man! this info helped me to resolve the issue.. :)

    ReplyDelete
  25. AnonymousApril 27, 2018 at 11:14 AM

    Thank you..it helped me... :)

    ReplyDelete
  26. AnonymousFebruary 24, 2019 at 8:34 AM

    Thanks dude, Able to find the cause...

    ReplyDelete
  27. Digital ChanduMarch 12, 2020 at 3:44 PM

    very 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

    Digital Marketing In Telugu
    Digital Marketing In Hyderabad
    internet marketing
    Digital marketing
    Digital Marketing Strategy

    ReplyDelete
  28. impotenceNovember 25, 2020 at 8:20 AM

    Hello, I wish for to subscribe for this webpage to get hottest updates, so where can i do it please help.

    ReplyDelete
  29. divyaFebruary 19, 2024 at 5:03 PM

    Nice
    Laundroway services in Hyderabad

    ReplyDelete
  30. SAP Masters Training Institute in BangaloreMay 10, 2024 at 8:12 AM

    "Looking to kickstart your career in SAP EWM? Bangalore offers a plethora of options for SAP EWM training.
    Here’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"

    ReplyDelete

comment

Subscribe to: Post Comments (Atom)