设为首页收藏本站
开启辅助访问 切换到窄版
搜索
第一问答网»论坛 › 中问网 › 问答 › exp时出现91的错误，这样的导出文件可以用吗 ...

exp时出现91的错误，这样的导出文件可以用吗

[复制链接]
查看11 | 回复5 | 2005-11-2 13:35:57 | 显示全部楼层 |阅读模式
$ exp
Export: Release 9.2.0.5.0 - Production on Mon Jul 25 09:43:32 2005
Copyright (c) 1982, 2002, Oracle Corporation.All rights reserved.

Username: zd
Password:
Connected to: Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
With the Partitioning option
JServer Release 9.2.0.5.0 - Production
Enter array fetch buffer size: 4096 >
Export file: EXPDAT.DMP > all_050725.dmp
(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > e
Export grants (yes/no): yes >
Export table data (yes/no): yes >
Compress extents (yes/no): yes >
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions
. exporting system procedural objects and actions
. exporting pre-schema procedural objects and actions
. exporting cluster definitions
. about to export SYSTEM's tables via Conventional Path ...
. . exporting table
AQ$_INTERNET_AGENTS
0 rows exported
. . exporting table AQ$_INTERNET_AGENT_PRIVS
0 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table
DBMS_ALERT_INFO
0 rows exported
. . exporting table
DBMS_LOCK_ALLOCATED
0 rows exported
. . exporting table
DEF$_AQCALL
0 rows exported
EXP-00091: Exporting questionable statistics.
. . . exporting table
CDT1 109414 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table
CDT1_END 17 rows exported
. . exporting table
CDT1_NO238463 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table
CDT_END74124 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table
CDT_NO2 47 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table
CDT_SI
0 rows exported
. . exporting table
CDT_TMP 13 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table
CMCAT
0 rows exported
. . exporting table
CMLKT
1 rows exported
. . exporting table
COIL_IN_TEMP
2 rows exported
. . exporting table
COIL_LIST 26 rows exported
. . exporting table
COIL_LIST_FLAG
0 rows exported
. . exporting table
COIL_OUT_TEMP
0 rows exported
. . exporting table
COIL_WEIGHT_YU 5722 rows exported
. . exporting table
CQCT13194 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table
CQCT_END21910 rows exported
. . exporting table
CQCT_ENDT
0 rows exported
. . exporting table
CQMT 2690 rows exported
. . exporting table
CQMT_DAILYT 3752 rows exported
. . exporting table
CRITTOCRIT313 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table
CSDAT
0 rows exported
. . exporting table
CSDBT
0 rows exported
. . exporting table
CSDCT640 rows exported
. . exporting table
CSDDT 34 rows exported
. . exporting table
CSDTT
0 rows exported
. . exporting table
CST 19 rows exported
. . exporting table
CT29958 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table
CT_END107 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table
CYAET
0 rows exported
. . exporting table
CYAT25912 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table
CYCPAET
0 rows exported
. . exporting table
CYCPAT27228 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table
CYCSET 49 rows exported
. . exporting table
CYCST 2125 rows exported
. . exporting table
DAILY_T_CUT 5566 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table
DLT 34 rows exported
. . exporting table
DPQIT(BU)
0 rows exported
. . exporting table
DPQTIT25141 rows exported
. . exporting table
DPQTS58890 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table
DPQTS_END
0 rows exported
. . exporting table
DPQTS_MANUAL345 rows exported
. . exporting table
DPQTS_PRINT
1 rows exported
. . exporting table
DPQTT 9220 rows exported
. . exporting table
DPQTT(BU)
0 rows exported
. . exporting table
DPQTT116044 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table
DPQTT1_END
0 rows exported
. . exporting table
DPQTT1_MANUAL260 rows exported
. . exporting table
DPQTT_END
0 rows exported
. . exporting table
DPQTT_REMARKS
0 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table
DPQTX_PRINT1
1 rows exported
. . exporting table
DPQTX_PRINT2
1 rows exported
. . exporting table
DRAWUP_RP_PARAM
1 rows exported
. . exporting table
EXCEPTIONS
0 rows exported
. . exporting table
FCRET
0 rows exported
. . exporting table
FCRT
0 rows exported
. . exporting table
FEEDBACKT30039 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table
FINANCE_DAILY
0 rows exported
. . exporting table
FINANCE_THICK
6 rows exported
. . exporting table
FINANCE_WIDTH
4 rows exported
. . exporting table
FPCET 4433 rows exported
. . exporting table
FPCT43521 rows exported
. . exporting table
FPSSET
0 rows exported
. . exporting table
FPSST11600 rows exported
. . exporting table
FSET103 rows exported
. . exporting table
FST 5811 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table
GLST133 rows exported
. . exporting table
GRADE_CODE 60 rows exported
. . exporting table
GRADE_NAME 15 rows exported
. . exporting table
HDLAET 2675 rows exported
. . exporting table
HDLAT28163 rows exported
. . exporting table
HDLCOIL 4411 rows exported
. . exporting table
HDLCOIL_NO2 2545 rows exported
. . exporting table
HDLFAULET 73 rows exported
. . exporting table
HDLFAULT14455 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table
HDLPT22817 rows exported
. . exporting table
HDLPT1
0 rows exported
. . exporting table
HDLPT_END27192 rows exported
. . exporting table
HDLPT_NO221933 rows exported
. . exporting table
HDLPT_NO2_BEI 6137 rows exported
. . exporting table
HDL_COIL
0 rows exported
. . exporting table
HDL_PLAN1
0 rows exported
. . exporting table
HDL_PLAN2
0 rows exported
. . exporting table
HDL_PRINT 25 rows exported
. . exporting table
HDL_SHIFT27905 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table
HDL_SHIFT_BEI31930 rows exported
. . exporting table
HDL_SHIFT_NO227398 rows exported
. . exporting table
HDL_SHIFT_NO2_BEI178 rows exported
. . exporting table
HDL_SUM
3 rows exported
. . exporting table
HGL_TAB600 rows exported
. . exporting table
HOTRP
0 rows exported
. . exporting table
I_DPQTX57329 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table
I_DPQTX_END
0 rows exported
. . exporting table
I_DPQTX_MANUAL254 rows exported
. . exporting table
L1ALARM1
0 rows exported
. . exporting table
MATT493 rows exported
. . exporting table
MBMT 3464 rows exported
. . exporting table
MERGE_RESULT
0 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table
MERGE_SIZE
4 rows exported
. . exporting table
MICROSOFTDTPROPERTIES
0 rows exported
EXP-00091: Exporting questionable statistics.
. about to export ZL's tables via Conventional Path ...
. . exporting table
RACT76243 rows exported
. . exporting table
RALLO4 14 rows exported
. . exporting table
RALLO4_YU 3253 rows exported
. . exporting table
RALLO6 14 rows exported
. . exporting table
RALLO6_YU28792 rows exported
. . exporting table
RALLOCATE 2679 rows exported
. . exporting table
RALLOCATE_TEST
0 rows exported
. . exporting table
RALLOCATE_YU 4133 rows exported
. . exporting table
RCHECK
1 rows exported
. . exporting table
REMPLOYEE 37 rows exported
. . exporting table
RGROUP213 rows exported
. . exporting table
RINFO761 rows exported
. . exporting table
RPARA1 32 rows exported
. . exporting table
RPARA3 13 rows exported
. . exporting table
RPROCESS71441 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table
RPROCESS_YU
0 rows exported
. . exporting table
RSTAT1
0 rows exported
. . exporting table
RSTAT2 18 rows exported
. . exporting table
RSTATE744 rows exported
. . exporting table
RSTATE_TEST
0 rows exported
. . exporting table
RWASTE407 rows exported
. . exporting table
TEST_YU 2593 rows exported
. . exporting table
USERPWD
7 rows exported
. about to export MANW's tables via Conventional Path ...
. . exporting table
INSCDT 99 rows exported
. . exporting table
LCRT12191 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table
LCT 1726 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table
MICROSOFTDTPROPERTIES
0 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table
SCT
0 rows exported
. . exporting table
TMP_DPQT 91 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table
USER_MANAGER
7 rows exported
. about to export SCOTT's tables via Conventional Path ...
. exporting synonyms
. exporting views
. exporting referential integrity constraints
. exporting stored procedures
. exporting operators
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting triggers
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting user history table
. exporting default and system auditing options
. exporting statistics
Export terminated successfully with warnings.
回复

使用道具 举报

千问 | 2005-11-2 13:35:57 | 显示全部楼层
从EXP-00091的文档来看，导入应该没问题，不过导入后可能会缺少一些东西，可以导入后把两个库比较一下，找找问题发生的原因
回复

使用道具 举报

千问 | 2005-11-2 13:35:57 | 显示全部楼层
没问题。
回复

使用道具 举报

千问 | 2005-11-2 13:35:57 | 显示全部楼层
我也遇到过，感觉上有什么问题，不过，后来把进了导入前的和用导出包导入的新数据比较，也没有发现少了什么，就没有去管了。
回复

使用道具 举报

千问 | 2005-11-2 13:35:57 | 显示全部楼层
分析后重新EXP，看看还有多少EXP-00091出现
回复

使用道具 举报

千问 | 2005-11-2 13:35:57 | 显示全部楼层
91这个错误是说客户端和SERVER端的字符集不符合，但是我是直接在SERVER端操作的，出现这个问题，很奇怪啊！
回复

使用道具 举报

返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

千问

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
回复楼主 返回列表
热门排行