EXP-00008: ORACLE error 6553 encountered
ORA-06553: PLS-561: character set mismatch on value for parameter 'SHORTNAME'
EXP-00000: Export terminated unsuccessfully[@more@]
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 --添加这一句
然后再导出就不会提示错误了!
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/188692/viewspace-902986/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
