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