请教oracle imp数据导入 问题!
原机器:
win2000 adv
oracle 9i
成功导出e.dmp文件
目标机:
win2000 adv
oracle 9i
e.dmp在e;\下面
操作1:
在目标机上建了新的表空间news和新用户news pw =pw
imp system/password file=e:/e.dmp fromuser=sysytem touser=news log=err20031016.log
错误1:
连接到: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
经由常规路径导出由EXPORT:V09.02.00创建的文件
已经完成ZHS16GBK字符集和AL16UTF16 NCHAR 字符集中的导入
导出客户机使用ZHS16CGB231280字符集 (可能的字符集转换)
. 正在将SYSTEM的对象导入到 NEWS
IMP-00015: 由于对象已存在,下列语句失败:
"CREATE TYPE "REPCAT$_OBJECT_NULL_VECTOR" TIMESTAMP '2002-05-12:16:38:08' OI"
"D '4C81ADEB677A408AB30291AB408EC1C9' AS OBJECT"
"("
" -- type owner, name, hashcode for the type represented by null_vector"
" type_owner VARCHAR2(30),"
" type_name VARCHAR2(30),"
" type_hashcode RAW(17),"
" -- null_vector for a particular object instance"
" -- ROBJ REVISIT: should only contain the null image, and not version#"
" null_vector RAW(2000)"
")"
IMP-00017: 由于 ORACLE 的 1031 错误,以下的语句失败
"CREATE DATABASE LINK "WAP.US.ORACLE.COM" CONNECT TO "SYSTEM" IDENTIFIED BY "
""MANAGER" USING 'wap'"
IMP-00003: 遇到 ORACLE 错误 1031
ORA-01031: 权限不足
IMP-00015: 由于对象已存在,下列语句失败:
"CREATE SEQUENCE "HISTORY_SEQ" MINVALUE 1 MAXVALUE 9999999999999999999999999"
"999 INCREMENT BY 1 START WITH 1122 CACHE 20 NOORDER NOCYCLE"
IMP-00015: 由于对象已存在,下列语句失败:
"CREATE SEQUENCE "LOGMNR_SEQ$" MINVALUE 1 MAXVALUE 9999999999999999999999999"
操作2:
imp system/password file=e:/e.dmp full=yes log=err20031016.log
错误2:
连接到: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
经由常规路径导出由EXPORT:V09.02.00创建的文件
已经完成ZHS16GBK字符集和AL16UTF16 NCHAR 字符集中的导入
导出客户机使用ZHS16CGB231280字符集 (可能的字符集转换)
. 正在将SYSTEM的对象导入到 NEWS
IMP-00015: 由于对象已存在,下列语句失败:
"CREATE TYPE "REPCAT$_OBJECT_NULL_VECTOR" TIMESTAMP '2002-05-12:16:38:08' OI"
"D '4C81ADEB677A408AB30291AB408EC1C9' AS OBJECT"
"("
" -- type owner, name, hashcode for the type represented by null_vector"
" type_owner VARCHAR2(30),"
" type_name VARCHAR2(30),"
" type_hashcode RAW(17),"
" -- null_vector for a particular object instance"
" -- ROBJ REVISIT: should only contain the null image, and not version#"
" null_vector RAW(2000)"
")"
IMP-00017: 由于 ORACLE 的 1031 错误,以下的语句失败
"CREATE DATABASE LINK "WAP.US.ORACLE.COM" CONNECT TO "SYSTEM" IDENTIFIED BY "
""MANAGER" USING 'wap'"
IMP-00003: 遇到 ORACLE 错误 1031
ORA-01031: 权限不足
IMP-00015: 由于对象已存在,下列语句失败:
"CREATE SEQUENCE "HISTORY_SEQ" MINVALUE 1 MAXVALUE 9999999999999999999999999"
"999 INCREMENT BY 1 START WITH 1122 CACHE 20 NOORDER NOCYCLE"
IMP-00015: 由于对象已存在,下列语句失败:
"CREATE SEQUENCE "LOGMNR_SEQ$" MINVALUE 1 MAXVALUE 9999999999999999999999999"
"99 INCREMENT BY 1 START WITH 1 CACHE 20 ORDER NOCYCLE"
IMP-00015: 由于对象已存在,下列语句失败:
请赐教。