Oracle8i导出出现EXP-8错误

最新推荐文章于 2021-04-14 08:30:32 发布
最新推荐文章于 2021-04-14 08:30:32 发布
阅读量179 收藏 1
点赞数
文章标签： java 数据库

碰到一个BUG，在8i数据库中执行导出出现了这个问题。

 

 

详细错误信息为：

C:\>exp system/manager@orcl file=c:\xxx\gufj.dmp wner=gufj rows=n

Export: Release 8.1.7.4.1 - Production on Wed Jan 12 11:57:38 2011

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.1 - Production
With the Partitioning option
JServer Release 8.1.7.4.1 - Production
Export done in US7ASCII character set and ZHS16GBK NCHAR character set
Note: table data (rows) will not be exported

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user GUFJ
. exporting object type definitions for user GUFJ
About to export GUFJ's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export GUFJ's tables via Conventional Path ...
. . exporting table          CLINIC_ITEM_DICT_COMM
. . exporting table          CLINIC_ITEM_DICT_COPY
. . exporting table     CLINIC_ITEM_NAME_DICT_COMM
. . exporting table     CLINIC_ITEM_NAME_DICT_COPY
.
.
.
. . exporting table                         S_FILE
. . exporting table                 TAKE_DRUG_DICT
. . exporting table       TREAT_PROJECT_ITEMS_2007
. . exporting table      TREAT_PROJECT_MASTER_2007
. exporting synonyms
EXP-00008: ORACLE error 904 encountered
ORA-00904: invalid column name
EXP-00000: Export terminated unsuccessfully

查询metalink发现是由于没有安装JAVA选项，但是存在指向DBMS_JAVA包的同义词，因此导致导出过程失败。Oracle在文档ID 1017276.102描述了这个问题。

可以通过彻底卸载java来解决这个问题：

C:\>sqlplus /nolog

SQL*Plus: Release 8.1.7.0.0 - Production on Wed Jan 12 11:59:12 2011

(c) Copyright 2000 Oracle Corporation.  All rights reserved.

SQL> conn /@orcl as sysdba
Connected.
SQL> @?/javavm/install/rmjvm.sql

PL/SQL procedure successfully completed.


JVMRMACTION
--------------------------------
FULL_REMOVAL

drop role javauserpriv
begin if :jvmrmaction = 'FULL_REMOVAL' then
*
ERROR at line 1:
ORA-29540: class oracle/aurora/mts/http/security/RdbmsHttpPolicy does not exist
ORA-06512: at "SYS.INITJVMAUX", line 17
ORA-06512: at line 3

 

PL/SQL procedure successfully completed.

  dbms_java.aurora_shutdown();
  *
ERROR at line 8:
ORA-06550: line 8, column 3:
PLS-00201: identifier 'DBMS_JAVA.AURORA_SHUTDOWN' must be declared
ORA-06550: line 8, column 3:
PL/SQL: Statement ignored


drop package get_error$
drop public synonym get_error$
drop trigger AURORA$SERVER$SHUTDOWN
drop trigger AURORA$SERVER$STARTUP
drop package sqljutl

PL/SQL procedure successfully completed.


JVMRMACTION
--------------------------------
FULL_REMOVAL

drop package dbms_java
drop PUBLIC SYNONYM dbms_java
drop FUNCTION dbj_long_name
drop function "NameFromLastDDL"
drop PUBLIC SYNONYM "NameFromLastDDL"
drop FUNCTION dbj_short_name
drop PUBLIC SYNONYM dbj_short_name

PL/SQL procedure successfully completed.


JVMRMACTION
--------------------------------
FULL_REMOVAL

    select SEQ from dba_java_policy where GRANTEE = 'JAVA_DEPLOY' ;
                    *
ERROR at line 6:
ORA-06550: line 6, column 21:
PLS-00201: identifier 'DBA_JAVA_POLICY' must be declared
ORA-06550: line 6, column 5:
PL/SQL: SQL Statement ignored
ORA-06550: line 6, column 12:
PLS-00320: the declaration of the type of this expression is incomplete or
malformed
ORA-06550: line 11, column 5:
PL/SQL: SQL Statement ignored
ORA-06550: line 14, column 5:
PLS-00201: identifier 'DBMS_JAVA.DISABLE_PERMISSION' must be declared
ORA-06550: line 14, column 5:
PL/SQL: Statement ignored
ORA-06550: line 15, column 5:
PLS-00201: identifier 'DBMS_JAVA.DELETE_PERMISSION' must be declared
ORA-06550: line 15, column 5:
PL/SQL: Statement ignored


drop TABLE java$policy$shared$table
drop ROLE java_deploy
begin if :jvmrmaction = 'FULL_REMOVAL' or :jvmrmaction = 'DOWNGRADE_8.1.7_TO_8.1
.6' then
*
ERROR at line 1:
ORA-29540: class oracle/aurora/mts/http/security/RdbmsHttpPolicy does not exist
ORA-06512: at "SYS.INITJVMAUX", line 17
ORA-06512: at line 4


drop TABLE java$policy$
drop SEQUENCE java$policy$sequence$
drop VIEW dba_java_policy
drop PUBLIC SYNONYM dba_java_policy
drop VIEW user_java_policy
drop PUBLIC SYNONYM user_java_policy
drop ROLE java_admin
begin if :jvmrmaction = 'FULL_REMOVAL' or :jvmrmaction = 'DOWNGRADE_8.1.6_TO_8.1
.5' then
*
ERROR at line 1:
ORA-29540: class oracle/aurora/mts/http/security/RdbmsHttpPolicy does not exist
ORA-06512: at "SYS.INITJVMAUX", line 17
ORA-06512: at line 9

 

PL/SQL procedure successfully completed.


JVMRMACTION
--------------------------------
FULL_REMOVAL

drop package JAVA_XA
drop PUBLIC SYNONYM JAVA_XA

PL/SQL procedure successfully completed.

alter rollback segment monster offline
drop rollback segment monster
create rollback segment monster storage (initial 100 k next 100 k maxextents
unlimited)
alter rollback segment monster online
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
drop synonyms with java targets
delete from java$rmjvm$aux2
insert into  java$rmjvm$aux2 (select o1.name from obj$ o1,obj$ o2 where
o1.type#=5 and o1.name=o2.name and o2.type#=29)
flush shared_pool
set transaction use rollback segment MONSTER
delete from dependency$
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
delete from error$
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
delete from objauth$
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
delete from javasnm$
set transaction use rollback segment MONSTER
delete from idl_ub1$
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
delete from idl_ub2$
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
delete from idl_char$
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
delete from idl_sb4$
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
delete from obj$
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
All java objects removed
alter rollback segment monster offline
drop rollback segment monster
flush shared_pool

PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.

SQL>

再次运行导出，问题解决：

SQL> exit
Disconnected from Oracle8i Enterprise Edition Release 8.1.7.4.1 - Production
With the Partitioning option
JServer Release 8.1.7.4.1 - Production

C:\>exp system/manager@orcl file=c:\xxx\gufj.dmp wner=gufj rows=n

Export: Release 8.1.7.4.1 - Production on Wed Jan 12 12:07:32 2011

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.1 - Production
With the Partitioning option
JServer Release 8.1.7.4.1 - Production
Export done in US7ASCII character set and ZHS16GBK NCHAR character set
Note: table data (rows) will not be exported

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user GUFJ
. exporting object type definitions for user GUFJ
About to export GUFJ's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export GUFJ's tables via Conventional Path ...
. . exporting table          CLINIC_ITEM_DICT_COMM
. . exporting table          CLINIC_ITEM_DICT_COPY
. . exporting table     CLINIC_ITEM_NAME_DICT_COMM
. . exporting table     CLINIC_ITEM_NAME_DICT_COPY
.
.
.
. . exporting table                         S_FILE
. . exporting table                 TAKE_DRUG_DICT
. . exporting table       TREAT_PROJECT_ITEMS_2007
. . exporting table      TREAT_PROJECT_MASTER_2007
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting snapshots
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.

Oracle没有将这个问题归类到bug中，但个人认为这显然属于bug的范畴，因为指向DBMS_JAVA的同义词也是Oracle在安装过程中自动创建的。

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/4227/viewspace-683788/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/4227/viewspace-683788/

ckawt40802
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
oracle导入导出exp00056,学习笔记:Oracle逻辑导出/导入 报错EXP-00056 ORA-01403 EXP-00000...
weixin_29975633的博客
04-07 679
天萃荷净Oracle数据库逻辑exp导出数据时报EXP-00056 ORA-01403 EXP-00000错误，分析原因为临时文件导致1.exp导出数据报EXP-00056/ORA-01403错误[oracle@xifenfei ~]$ exp chf/xifenfei file=/tmp/chf.dmp log=/tmp/chf.log owner=chfExport: Release 9.2....
oracle导出表exp00056,ORACLE导出异常-EXP-00056: 遇到 ORACLE 异常 600
weixin_33900916的博客
04-07 1273
ORACLE导出错误-EXP-00056: 遇到 ORACLE 错误 600点击右边红色标题查看本文完整版：ORACLE导出错误-EXP-00056: 遇到 ORACLE 错误 600即将导出指定的用户.... 正在导出 pre-schema 过程对象和操作. 正在导出用户 GMS 的外部函数库名称. 导出 PUBLIC 类型同义词. 导出私有类型同义词. 正在导出...
mysql 导入oracle数据库命令_oracle数据库导入导出命令！
weixin_29726381的博客
02-27 86
Oracle数据导入导出imp/exp功能：Oracle数据导入导出imp/exp就相当与oracle数据还原与备份。大多情况都可以用Oracle数据导入导出完成数据的备份和还原(不会造成数据的丢失)。Oracle有个好处，虽然你的电脑不是服务器，但是你装了oracle客户端，并建立了连接(通过Net Configuration Assistant添加正确的服务命名，其实你可以想成是客户端与服务器...
oracle8i导出详细步骤,迁移案例一: oracle 8i 文件迁移
weixin_29813635的博客
04-04 167
前两天去客户那，因为客户使用到的盘柜存储通过检测发现可能有问题，为了防止数据文件丢失需要迁移到好的存储硬盘上 客户版本是oracle8i+IBM aix 平台需要迁移的有控制文件，数据文件，重做日志文件首先关闭数据库1.控制文件迁移1.1 修改初始化参数 vi init.ora 使控制文件参数对应上新迁移的目录1.2 拷贝控制文件到新目录下cp /oradata/oradata1/contro...
oracle根据addr,调用utl_inaddr.get_host_name时报错ora-29540
weixin_32314595的博客
04-14 647
数据库为Oracle 8.1.6，安装在本机，操作系统windows 2003错误如下:SQL> select utl_inaddr.get_host_name from dual;select utl_inaddr.get_host_name from dual*ERROR 位于第 1 行:ORA-29540: 类oracle/plsql/net/InternetAddress不存在ORA...
Oracle异常ORA-29538、ORA-29540
sunny05296的博客
05-20 4058
遇到的Oracle错误1： ORA-29538: Java not installed ORA-06512: at "SYS.DBMS_CDC_PUBLISH", line 1017 ORA-06512: at line 2 原因：Oracle数据库JVM组件(JServer JAVA Virtual Machine)没有安装 遇到的Oracle错误2： ORA-29540:
Install JVM
阿锋的专栏
11-26 1519
Modified:07-Jan-2014Type:HOWTO Language: English??? In this Document Goal
oracle11gR2使用exp导出命令时报EXP-00011错误的解决方法
01-19
执行EXP导出时，部分表提示 EXP-00011:表不存在错误,但是查询user_all_tables视图，此表确实是存在的，并且执行select语句也能成功，不过表为空表，查看权限等也没有问题。后来通过查询资料，发现问题是由Deferred ...
oracle exp0006,EXP-00006: 出现内部不一致的错误
weixin_39617113的博客
04-04 2453
C:Userscpc-1>exp help=yExport: Release 11.1.0.6.0 - Production on 星期五 9月 23 10:34:01 2011Copyright (c) 1982, 2007, Oracle. All rights reserved.通过输入 EXP 命令和您的用户名/口令, 导出操作将提示您输入参数:例如: EXP SCOTT/TIGE...
ORA-29540: 类oracle/CDC/PublishApi不存在
cuiqingko849622的博客
07-19 656
在使用cdc时报错解决方法：@。。。。/rdbms/admin/rmcdc.sql@。。。。/rdbms/admin/initcdc.sql ...
EXP-00008: 遇到 ORACLE 错误 904
u014566910的专栏
12-10 9843
连接到: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Produc tion With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options 已导出 ZHS1
exp导出报错EXP-00008: ORACLE error 4031 encountered
十月空空的专栏
05-16 2024
导出exp失败 . exporting synonyms EXP-00008: ORACLE error 4031 encountered ORA-04031: unable to allocate 4096 bytes of shared memory ("java pool","java/lang/StringBuffer","joxlod exec hp","SGAClass") E
EXP-00008: ORACLE error 29516 encountered ORA-29516: Aurora assertion failure: Assertion failure at
qq_42742994的博客
06-02 1578
执行exp导出dmp命令 exp animalmanager/root file=/install/database/20200602.dmp owner=animalmanager 报错如下 EXP-00008: ORACLE error 29516 encountered ORA-29516: Aurora assertion failure: Assertion failure at joez.c:3311 Bulk load of method java/lang/Object. failed;
Oracle_exp导出数据异常
xiaoxu oracle专栏
12-25 837
[history_oracle@xxx] exp  \"/ as sysdba\"  file=/arch1/data_bak151225/BAK_MH_USERLOGINFO_0525.dmp owner=SDCASSO tables=BAK_MH_USERLOGINFO_0525 log=/arch1/data_bak151225/BAK_MH_USERLOGINFO_0525.log
oracle9i在进行全库备份时出现EXP-00008: ORACLE error 1187 encountered的解决办法
zhengcairong520yao的专栏
06-17 1517
oracle9i在进行数据库全库备份时出现如下错误： Connected to: Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.8.0 - Production
EXP-00008: ORACLE error 6550 encountered 报错
makef的博客
01-05 5292
exp  user/passwd    file=/oracle.bak/data.$(date  +%Y-%m-%d).dmp  log=/oracle.bak/data.$(date  +%Y-%m-%d).log   full=y Connected to: Oracle Database 11g Release 11.2.0.1.0 - 64bit Production Export
EXP-00008: ORACLE error 904 encountered的解决方法
csdn20142的博客
06-06 1100
EXP-00008: ORACLE error 904 encountered的解决方法 　　 【错误情况】 [oracle@ccdevsvr admin]$ exp wmap/pass@...
EXP-00008: ORACLE error 904 encountered
huangliang0703的专栏
06-26 1580
C:\Users\Administrator>exp huang1/huang1@redhat tables=t file=c:\exp.dmp Export: Release 11.2.0.1.0 - Production on Thu Jun 26 11:34:33 2014 Copyright (c) 1982, 2009, Oracle and/or its affil
java程序造成ora-7445_impdp 导入在PROC_SYSTEM_GRANT时停滞，不断生成JAVA$POLICY$SHARED$00......
weixin_39949894的博客
02-26 107
某大牛的回复 .I don't have a solution to your problem. But these are definitely not temporary tables, which would take the form .. If the problem is reproducible, you may want to open an SR.JAVA$POLICY is t...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值