在用exp导出Oracle9i数据的时候出现错误
错误信息:
.正在导出集群定义
EXP-00056:遇到ORACLE错误19206
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 345
ORA-06512:at "SYS.DBMS_METADATA",line 410
ORA-06512:at "SYS.DBMS_METADATA",line 449
ORA-06512:at "SYS.DBMS_METADATA",line 1156
ORA-06512:at "SYS.DBMS_METADATA",line 1141
ORA-06512:at line 1
EXP-00000:导出终止失败
-------------------------------------------------------------------------
原来的时候导出都是好的,今天突然有问题了
同时导出好几个方案的,只有一个能导,
第一个方案的导出完之后,其他的又可以同时导出了,
很奇怪的问题,
google了一下,说是Oracle9i的一个bug,要执行一下/ora92/rdbms/admin/catpatch.sql,
郁闷
还没有搞懂什么问题,没有执行
catpatch.sql的内容:
Rem
Rem $Header: catpatch.sql 15-oct-2001.07:37:43 rburns Exp $
Rem
Rem catpatch.sql
Rem
Rem Copyright (c) 2001, Oracle Corporation. All rights reserved.
Rem
Rem NAME
Rem catpatch.sql - Script to apply CATalog PATCH set to a database
Rem
Rem DESCRIPTION
Rem This script encapsulates the "post install" steps necessary
Rem to migrate the dictionary to the new patchset version.
Rem It runs the new patchset versions of catalog.sql and catproc.sql.
Rem
Rem NOTES
Rem Use SQLPLUS and connect AS SYSDBA to run this script.
Rem
Rem MODIFIED (MM/DD/YY)
Rem rburns 10/15/01 - add scope argument
Rem rburns 10/10/01 - Merged rburns_patchset_tests
Rem rburns 09/26/01 - Version for 9.0.1.2.0 patchset
Rem rburns 09/26/01 - Created
Rem
Rem =======================================================================
Rem Initialize SYSTEM parameters to avoid errors with catalog and catproc
Rem =======================================================================
WHENEVER SQLERROR EXIT;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET "_system_trig_enabled"=FALSE SCOPE=MEMORY;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0 SCOPE=MEMORY;
ALTER SYSTEM SET AQ_TM_PROCESSES=0 SCOPE=MEMORY;
ALTER SYSTEM SET NLS_LENGTH_SEMANTICS=BYTE SCOPE=MEMORY;
Rem =======================================================================
Rem Set event to avoid unnecessary re-compilations while
Rem catalog.sql and catproc.sql are run
Rem =======================================================================
ALTER SESSION SET EVENTS '10520 TRACE NAME CONTEXT FOREVER, LEVEL 10';
WHENEVER SQLERROR CONTINUE;
Rem =======================================================================
Rem Run catalog.sql and catproc.sql
Rem utlil.sql invalidates library dependents only
Rem =======================================================================
Rem Remove any existing rows that would fire on DROP USER statements
delete from duc$;
@@utlil.sql
@@catalog.sql
@@catproc.sql
Rem =======================================================================
Rem Turn SESSION event off
Rem =======================================================================
ALTER SESSION SET EVENTS '10520 TRACE NAME CONTEXT OFF';
Rem ***********************************************************************
Rem End of catpatch.sql
Rem ***********************************************************************
-------------------------
没有看明白是什么意思