Home » RDBMS Server » Server Administration » OCI-21560: argument 7 is null, invalid, or out of range
OCI-21560: argument 7 is null, invalid, or out of range [message #63600] Tue, 19 October 2004 22:07 Go to next message
Mukesh Raj Singh
Messages: 9
Registered: March 2003
Junior Member
Hi,

I have installed oracle 9i release 2 installed on windows 2000 server. I imported data from earlier instaaled database 8.0.3.  After importing objects into the newly installed database I am facing the problem in full database export even I ran utlrp,catproc,catexp etc scripts. It gives the error:

. about to export ODM's tables via Conventional Path ...
. . exporting table          CREATE$JAVA$LOB$TABLE          0 rows exported
. . exporting table                DMS_QUEUE_TABLE
EXP-00056: ORACLE error 21560 encountered
OCI-21560: argument 7 is null, invalid, or out of range

. exporting views
EXP-00056: ORACLE error 21560 encountered
OCI-21560: argument 7 is null, invalid, or out of range
EXP-00056: ORACLE error 21560 encountered
OCI-21560: argument 7 is null, invalid, or out of range
EXP-00000: Export terminated unsuccessfully

Here is the list of invalid objects in my database.

OE              TYPE               CATALOG_TYP
OE              TYPE               COMPOSITE_CATEGORY_TYP
OE              TYPE               CATEGORY_TYP
OE              TYPE               LEAF_CATEGORY_TYP
SYS             TYPE               ODCIARGDESC
SYS             TYPE               ODCIINDEXINFO
SYS             TYPE               ODCIINDEXINFO
SYS             TYPE               ODCICOLINFO
SYS             TYPE               ODCICOST
WKSYS        PACKAGE BODY       WK_CRW
XDB             PROCEDURE          XDB$PATCHUPSCHEMA
XDB             PROCEDURE          XDB$PATCHUPDELETESCHEMA
XDB             VIEW               RESOURCE_VIEW
XDB             TRIGGER            XDB_RV_TRIG
XDB             TRIGGER            XDB$ACL_xdbpt
XDB             XML SCHEMA         XD6og1dpvWRp2783XLf2dJag==
XDB             TRIGGER            SERVLET_xdbpt
XDB             XML SCHEMA         XDeL+R1jTrS02oYnnC3qW43A==
XDB             TRIGGER            xdb-log9_TAB_xdbpt
XDB             XML SCHEMA         XDeANTEZn/R7WgoNhsuVu7OA==
XDB             TRIGGER            ftp-log14_TAB_xdbpt
XDB             XML SCHEMA         XDefPU46scRPORRSMMAaNvAA==
XDB             TRIGGER            http-log20_TAB_xdbpt
XDB             XML SCHEMA         XDHmlQI6HpQoWwQTjZDrAysw==
XDB             PACKAGE BODY       DBMS_XDB_VERSION
XDB             VIEW               PATH_VIEW
XDB             TRIGGER            XDB_PV_TRIG
XDB             TRIGGER            XDB$CONFIG_xdbpt 

Kindly look into the rpoblem and suggest me what to do  next to get rid of this problem.

Thanks in advance.

Regards

Raj

 

 

 

Report message to a moderator

Re: OCI-21560: argument 7 is null, invalid, or out of range [message #63605 is a reply to message #63600] Wed, 20 October 2004 03:48 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Unless you are using the XDB,OEM options you no need to worry about these.
These schemas are controlled by oracle ( oracle options). If you intend to use it in 9i you have to INSTALL them properly in 9i or ugrade from 803( Go through a proper upgrade path. from 803 to 8i,8i to 9i using Upgrade utilities.).
A simple export and import might work only for YOUR coustom schemas (where you have your data) and NOT FOR sys / XDB / XMLDB and other oracle options.

Report message to a moderator

Re: OCI-21560: argument 7 is null, invalid, or out of range [message #63689 is a reply to message #63605] Thu, 28 October 2004 03:51 Go to previous message
Mukesh Raj Singh
Messages: 9
Registered: March 2003
Junior Member
Hi
Thanks for ur suggestion.
Can u tell me what default user do we have to keep so that our database work fine.
we are not using oracle datamining.
Si if I drop ODM does this will affect our business.

Thanks
Mukesh

Report message to a moderator

Previous Topic: oracle 9 redo log format
Next Topic: exp, mknod
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 24 19:17:32 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.