Chinaunix

标题: exp数据出不来 [打印本页]

作者: sigin    时间: 2007-02-09 08:48
标题: exp数据出不来
我有一台服务器,装的还是很老的ORACLE7.3.4,最近在做EXP数据导出时,发现不能成功,提示如下:
Connected to: Oracle7 Server Release 7.3.4.0.0 - Production
With the distributed, replication and parallel query options
PL/SQL Release 2.3.4.0.0 - Production
Export done in ZHS16CGB231280 character set
Note: table data (rows) will not be exported
About to export LY_USER's objects ...
. exporting snapshots
. exporting snapshot logs
. exporting job queues
EXP-00008: ORACLE error 1089 encountered
ORA-01089: immediate shutdown in progress - no operations are permitted
ORA-06512: at "SYS.DBMS_JOB", line 87
ORA-06512: at "SYS.DBMS_JOB", line 230
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully
用system用户导这个用户的数据也不行,数据库关闭或开启都是正常的,没有错误提示,请问是哪儿出问题了呢,谢谢
作者: donniejeck    时间: 2007-02-09 09:33
建议帖子alter.log日志上来看看.
作者: sigin    时间: 2007-02-09 10:05
$ exp user/pass file=a.dmp

Export: Release 7.3.4.0.0 - Production on Fri Feb  9 10:01:21 2007

Copyright (c) Oracle Corporation 1979, 1996.  All rights reserved.


Connected to: Oracle7 Server Release 7.3.4.0.0 - Production
With the distributed, replication and parallel query options
PL/SQL Release 2.3.4.0.0 - Production
Export done in ZHS16CGB231280 character set

About to export specified users ...
About to export LY_USER's objects ...
. exporting snapshots
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting database links
. exporting sequence numbers
一直停在这儿,再也下不进了,只能杀进程才能退出来,退出后select * from dba_sequences也半天出不来,查看alter日志,出现600代Fri Feb  9 10:01:22 2007
Errors in file /oracle7/admin/ly/udump/ora_23007.trc:
ORA-00600: internal error code, arguments: [12700], [134218117], [12], [], [], [], [], []
码:
要从何查起呢,郁




欢迎光临 Chinaunix (http://bbs.chinaunix.net/) Powered by Discuz! X3.2