error 21560 during exports

From: Bill Wagman <wjwagman_at_ucdavis.edu>
Date: Wed, 26 Apr 2000 13:32:28 -0700
Message-Id: <10479.104231@fatcity.com>

During a daily export I encounter the following errors on several tables in one users schema

. . exporting

table                                                       DEPART

EXP-00056: ORACLE error 21560 encountered OCI-21560: argument 7 is null, invalid or out of range

Note:1017260.102 on metalink reports a similar situation for views and suggests deleting the views that don't exist based on ckecking user_views. In my case the tables do exist but according to the status as listed in dba_objects it is invalid. I have never seen an invalid table. I am not able to describe it, sql returns the following...

ERROR
ORA-24372: invalid object for describe

I believe the user may have been attempting to use object features of oracle to create the table but I have not yet heard from the user.

Any suggestions as to how to track this down or fix the problem will be most welcome.

Thanks.

Bill Wagman
Univ. of California at Davis
Information Resources
wjwagman_at_ucdavis.edu
(530) 754-6208

---

Why is it that when you're driving and looking for an address, you turn down the volume on the radio? Received on Wed Apr 26 2000 - 15:32:28 CDT