 Posted 7/28/2009 3:47:31 PM
|
|
|
|
Hi, I'm getting the following error code when exporting : EXP-00056: ORACLE error 19206 encountered during an export I was getting this while exporting entire schema: EXP-00056: ORACLE error 19206 encountered
ORA-19206: Invalid value for query or REF CURSOR parameter
ORA-06512: at "SYS.DBMS_XMLGEN", line 83
ORA-06512: at "SYS.DBMS_METADATA", line 353
ORA-06512: at "SYS.DBMS_METADATA", line 418
ORA-06512: at "SYS.DBMS_METADATA", line 457
ORA-06512: at "SYS.DBMS_METADATA", line 1181
ORA-06512: at "SYS.DBMS_METADATA", line 1162
ORA-06512: at line 1
EXP-00056: ORACLE error 19206 encountered
ORA-19206: Invalid value for query or REF CURSOR parameter
ORA-06512: at "SYS.DBMS_XMLGEN", line 83
ORA-06512: at "SYS.DBMS_METADATA", line 353
ORA-06512: at "SYS.DBMS_METADATA", line 418
ORA-06512: at "SYS.DBMS_METADATA", line 457
ORA-06512: at "SYS.DBMS_METADATA", line 1181
ORA-06512: at "SYS.DBMS_METADATA", line 1162
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully
(END) I couldn't figure it out at first and tried and verified all my settings. Then I came across a find where there was a mention of xmldb modification. Recently there was and it might have been corrrupted. I connected as sysdba and ran the following and it fixed it: $ORACLE_HOME/rdbms/admin/catmeta.sql |
|
|
|
Posted 7/28/2009 3:52:35 PM
|
|
|
|
| The error: EXP-00056 was very generic and i ran into another occurence where I was trying to from difference versions. When trying to use exp utility on DB 9.0.2.3.0 connect to export data from DB 8.1.6 with tables option.
Export: Release 9.2.0.3.0 - Production on Sat Jun 28 2:12:04 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Password:
Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0, 64 bit - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
EXP-00056: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00000: Export terminated unsuccessfully
And the problem is that you can't export any DB with an exp utility of a newer version.
The exp version must be equal or older than the DB version. Hope this helps.
|
|
|
Posted 7/28/2009 4:02:12 PM
|
|
|
|
Again, Another generic EXP-00056 error. this time it's regarding a view:This is on a 10.1.0.2 database, when i got this when exporting a schema:
EXP-00056: ORACLE error 21560 encountered
OCI-21560: argument 7 is null, invalid, or out of range
I was getting this error because of a view in an invalid state.
Basically what this means is that there is a view that can't be successfully compiled. When this happens you'll get this error.
I just removed the view entirely or you can fix the problem with the view, otherwise you'll not be able to get a good export going.
Hope this helps. Thanks, |
|
|
|