论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2003-01-21 10:52 |只看该作者 |倒序浏览

使用如下命令进行Oracle数据库数据的导出:
exp dbuser/pw file=oradb.dmp log=oradb.log full=y

导出了一部分数据，但是到了最后出来一个错误的提示如下：
EXP-00008:ORACLE error 6553 encountered
ORA-06553

LS-561:character set mismatch on value for parameter 'SHORTNAME'
EXP-00000:Export terminated unsuccessfully

Oracle数据库的环境位:TurboLinux DataServer6.5+ Oracle 816

请各位帮忙，请问各位出现如上的错误，我该如何解决！
谢谢！

文库|博客

yikaikai

富足长乐

论坛徽章:: 0

2楼 [报告]

发表于 2003-01-21 11:05 |只看该作者

数据导出时候出错！请大家帮忙！{包括错误提示}

Check if Java option is installed:
SELECT count(*) FROM dba_objects WHERE object_type LIKE 'JAVA%';
->; this select should return more than 4000 rows

Also issue as user SYS:
SELECT dbms_java.longname(name) FROM obj$ WHERE type# = 29 and status != 1;
->; this normally should return 0 rows, otherwise will fail with error
ORA-6553 PLS-561.

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

★可乐∮

家境小康

论坛徽章:: 0

3楼 [报告]

发表于 2003-01-21 11:29 |只看该作者

数据导出时候出错！请大家帮忙！{包括错误提示}

但是出现这个问题怎么去解决呢？
你只是告诉我去查询问题，请你告诉我解决方法！
谢谢！

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

yikaikai

富足长乐

论坛徽章:: 0

4楼 [报告]

发表于 2003-01-21 11:32 |只看该作者

数据导出时候出错！请大家帮忙！{包括错误提示}

If you do not need Java Option, first remove it by script:
$ORACLE_HOME/javavm/install/rmjvm.sql
(Notice that in 8.1.6 rmjvm.sql is wrong. Before running it you
should change line:
"call rmjvm.run(true)" to "execute rmjvm.run(true)"
This is due to [BUG].
Be careful for having large rollback segments when running it.

and then reinstall Java option:
All scripts are located in the $OH/javavm/install
initjvm.sql

but I never try it, so be careful.

Good luck