EXP-00056: ORACLE error 21560 encountered
OCI-21560: argument 7 is null, invalid, or out of range
After some research on metalink, it turned out that the culprit was a view in a permanent invalid state.
In other words, if there is a view that can't be successfully compiled, you'll get this nasty error that truncates your db dump.
As far as i know, either you remove the view entirely or you fix the problem with the view, otherwise you'll not be able to move forward.
If you don't want to remove the offending object and you don't have time to search for a solution, my suggestion is to comment out the problematic query and add a select with fixed values from dual such that you can compile the view, while retaining the old logic.
No comments:
Post a Comment
I appreciate your comment however bear in mind that I might not have the time to reply soon.
Normally I do not reply to all comments but I am glad if you found something useful or if you learned something new, in that case I strongly encourage you to promote the article with the +1 google button.
Flavio