Tuesday, November 22, 2005


I was trying to take an export of a certain schema on a database, when i got this:

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:

yes you can!

Two great ways to help us out with a minimal effort. Click on the Google Plus +1 button above or...
We appreciate your support!

latest articles