how to delete from user_errors
Dan AJun 3 2009 — edited Jun 3 2009As part of SR, need to delete from user_errors.
This is a view, owned by sys.
So, deleted from the view as sys, and when we do a select text we can see nothing.
Yet, when connected as apps, we can still see text in the view.
How can we delete all from this view?
This is all because we cannot recompile an object and we need to see the errors and upload to SR
Thanks.
Oracle 10.2
DA