在用exp导出Oracle9i数据的时候出现错误

在用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 ***********************************************************************

-------------------------

没有看明白是什么意思

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值