oracle 8i exp,oracle 8i的EXP-00008错误

EXP-00008: ORACLE error 6553 encountered

ORA-06553: PLS-561: character set mismatch on value for parameter 'SHORTNAME'

EXP-00000: Export terminated unsuccessfully[@more@]

SQL>conn / as sysdba

SQL> col view_name format a15

SQL> col text format a60

SQL> set long 10000000

SQL> select text from dba_views where view_name = ' EXU81JAVT'

TEXT

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

SELECT obj#

FROM sys.obj$

WHERE name = 'oracle/aurora/rdbms/DbmsJava'

AND type# = 29

AND owner# = 0

AND status = 1

更新改视图:

SQL>CREATE OR REPLACE VIEW EXU81JAVT

(objid)

AS

SELECT obj#

FROM sys.obj$

WHERE name = 'oracle/aurora/rdbms/DbmsJava'

AND type# = 29

AND owner# = 0

AND status = 1

and 1 = 0 --添加这一句

然后再导出就不会提示错误了!

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值