D:\>imp system/[email protected] file=d:\zhou.dmp fromuser=zhou;Import: Release 10.2.0.1.0 - Production on 星期四 7月 19 14:22:45 2007Copyright (c) 1982, 2005, Oracle. All rights reserved.
连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options经由常规路径由 EXPORT:V09.00.01 创建的导出文件警告: 这些对象由 ZHOU 导出, 而不是当前用户已经完成 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集中的导入
. 正在将 ZHOU 的对象导入到 SYSTEM
IMP-00034: 警告: 在导出文件中未找到 FromUser "ZHOU;"
成功终止导入, 但出现警告。
连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options经由常规路径由 EXPORT:V09.00.01 创建的导出文件警告: 这些对象由 ZHOU 导出, 而不是当前用户已经完成 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集中的导入
. 正在将 ZHOU 的对象导入到 SYSTEM
IMP-00034: 警告: 在导出文件中未找到 FromUser "ZHOU;"
成功终止导入, 但出现警告。
IMP-00017: 由于 ORACLE 错误 942, 以下语句失败:
"CREATE DIMENSION "TIMES_DIM" LEVEL "DAY" IS ("TIMES"."TIME_ID") LEVEL "MON
"H" IS ("TIMES"."CALENDAR_MONTH_DESC") LEVEL "QUARTER" IS ("TIMES"."CALENDA
"_QUARTER_DESC") LEVEL "YEAR" IS ("TIMES"."CALENDAR_YEAR") LEVEL "FIS_WEEK"
"IS ("TIMES"."WEEK_ENDING_DAY") LEVEL "FIS_MONTH" IS ("TIMES"."FISCAL_MONTH
"DESC") LEVEL "FIS_QUARTER" IS ("TIMES"."FISCAL_QUARTER_DESC") LEVEL "FIS_Y
"AR" IS ("TIMES"."FISCAL_YEAR") HIERARCHY "CAL_ROLLUP" ("DAY" CHILD OF "MON
"H" CHILD OF "QUARTER" CHILD OF "YEAR") HIERARCHY "FIS_ROLLUP" ("DAY" CHILD
"OF "FIS_WEEK" CHILD OF "FIS_MONTH" CHILD OF "FIS_QUARTER" CHILD OF "FIS_YE
"R") ATTRIBUTE "DAY" DETERMINES "TIMES"."DAY_NUMBER_IN_WEEK" ATTRIBUTE "DAY
" DETERMINES "TIMES"."CALENDAR_WEEK_NUMBER" ATTRIBUTE "DAY" DETERMINES "TIM
"S"."DAY_NUMBER_IN_MONTH" ATTRIBUTE "DAY" DETERMINES "TIMES"."DAY_NAME" ATT
"IBUTE "MONTH" DETERMINES "TIMES"."CALENDAR_MONTH_DESC" ATTRIBUTE "MONTH" D
"TERMINES "TIMES"."END_OF_CAL_MONTH" ATTRIBUTE "MONTH" DETERMINES "TIMES"."
"AYS_IN_CAL_MONTH" ATTRIBUTE "MONTH" DETERMINES "TIMES"."CALENDAR_MONTH_NAM
"" ATTRIBUTE "MONTH" DETERMINES "TIMES"."CALENDAR_MONTH_NUMBER" ATTRIBUTE "
"UARTER" DETERMINES "TIMES"."CALENDAR_QUARTER_DESC" ATTRIBUTE "QUARTER" DET
"RMINES "TIMES"."END_OF_CAL_QUARTER" ATTRIBUTE "QUARTER" DETERMINES "TIMES"
""DAYS_IN_CAL_QUARTER" ATTRIBUTE "QUARTER" DETERMINES "TIMES"."CALENDAR_QUA
"TER_NUMBER" ATTRIBUTE "YEAR" DETERMINES "TIMES"."CALENDAR_YEAR" ATTRIBUTE
"YEAR" DETERMINES "TIMES"."END_OF_CAL_YEAR" ATTRIBUTE "YEAR" DETERMINES "TI
"ES"."DAYS_IN_CAL_YEAR" ATTRIBUTE "FIS_WEEK" DETERMINES "TIMES"."WEEK_ENDIN
"_DAY" ATTRIBUTE "FIS_WEEK" DETERMINES "TIMES"."FISCAL_WEEK_NUMBER" ATTRIBU
"E "FIS_MONTH" DETERMINES "TIMES"."FISCAL_MONTH_DESC" ATTRIBUTE "FIS_MONTH"
"DETERMINES "TIMES"."END_OF_FIS_MONTH" ATTRIBUTE "FIS_MONTH" DETERMINES "TI
"ES"."DAYS_IN_FIS_MONTH" ATTRIBUTE "FIS_MONTH" DETERMINES "TIMES"."FISCAL_M
"NTH_NAME" ATTRIBUTE "FIS_MONTH" DETERMINES "TIMES"."FISCAL_MONTH_NUMBER" A
"TRIBUTE "FIS_QUARTER" DETERMINES "TIMES"."FISCAL_QUARTER_DESC" ATTRIBUTE "
"IS_QUARTER" DETERMINES "TIMES"."END_OF_FIS_QUARTER" ATTRIBUTE "FIS_QUARTER
" DETERMINES "TIMES"."DAYS_IN_FIS_QUARTER" ATTRIBUTE "FIS_QUARTER" DETERMIN
"S "TIMES"."FISCAL_QUARTER_NUMBER" ATTRIBUTE "FIS_YEAR" DETERMINES "TIMES".
"FISCAL_YEAR" ATTRIBUTE "FIS_YEAR" DETERMINES "TIMES"."END_OF_FIS_YEAR" ATT
"IBUTE "FIS_YEAR" DETERMINES "TIMES"."DAYS_IN_FIS_YEAR""
IMP-00003: 遇到 ORACLE 错误 942
ORA-00942: 表或视图不存在
即将启用约束条件...
成功终止导入, 但出现警告。
为什么会出现这么多错误啊,请各位执教,谢谢!!
举例:
导出
exp system/[email protected] file=d:\zhou.dmp owner=zhou
导入
imp system/[email protected] file=d:\zhou.dmp fromuser=zhou touser=....如果不是通过以上exp方式导出,按照你的imp肯定出错 需要重导