大哥大姐帮帮忙！！imp报错！！！

btxtguo

连接到: 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 字符集中的导入
. 正在将OFSS2000的对象导入到 OFSS2000
IMP-00015: 由于对象已存在，下列语句失败:
"CREATE SEQUENCE "TOF_CSMKID" MINVALUE 1 MAXVALUE 99999999999999999999999999"
"9 INCREMENT BY 1 START WITH 24 CACHE 20 NOORDER NOCYCLE"
IMP-00015: 由于对象已存在，下列语句失败:
"CREATE SEQUENCE "TOF_DRJJMXLSH" MINVALUE 1 MAXVALUE 99999999999999999999999"
"9999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: 由于对象已存在，下列语句失败:
"CREATE SEQUENCE "TOF_JGMXLSH" MINVALUE 1 MAXVALUE 9999999999999999999999999"
"99 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: 由于对象已存在，下列语句失败:
"CREATE SEQUENCE "TOF_JJDJMXLSH" MINVALUE 1 MAXVALUE 99999999999999999999999"
"9999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: 由于对象已存在，下列语句失败:
"CREATE SEQUENCE "TOF_JJFHNO" MINVALUE 1 MAXVALUE 99999999999999999999999999"
"9 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: 由于对象已存在，下列语句失败:
"CREATE SEQUENCE "TOF_JJWTZRBH" MINVALUE 1 MAXVALUE 999999999999999999999999"
"999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: 由于对象已存在，下列语句失败:
"CREATE SEQUENCE "TOF_ZHWTZRBH" MINVALUE 1 MAXVALUE 999999999999999999999999"
"999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: 由于对象已存在，下列语句失败:
"CREATE SEQUENCE "TOF_ZJQSLSH" MINVALUE 1 MAXVALUE 9999999999999999999999999"
"99 INCREMENT BY 1 START WITH 61 CACHE 20 NOORDER NOCYCLE"
IMP-00015: 由于对象已存在，下列语句失败:
"CREATE SEQUENCE "TOF_ZJQS_SHLSH" MINVALUE 1 MAXVALUE 9999999999999999999999"
"99999 INCREMENT BY 1 START WITH 21 CACHE 20 NOORDER NOCYCLE"
IMP-00015: 由于对象已存在，下列语句失败:
"CREATE SEQUENCE "TOF_ZKLBH" MINVALUE 1 MAXVALUE 999999999999999999999999999"
" INCREMENT BY 1 START WITH 21 CACHE 20 NOORDER NOCYCLE"
IMP-00015: 由于对象已存在，下列语句失败:
"CREATE SEQUENCE "TWORKLSH" MINVALUE 1 MAXVALUE 999999999999999999999999999 "
"INCREMENT BY 1 START WITH 62 CACHE 20 NOORDER NOCYCLE"
IMP-00015: 由于对象已存在，下列语句失败:
"CREATE SEQUENCE "VOF_JGMXLSH" MINVALUE 1 MAXVALUE 9999999999999999999999999"
"99 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: 由于对象已存在，下列语句失败:
"CREATE SEQUENCE "VOF_JJDJMXLSH" MINVALUE 1 MAXVALUE 99999999999999999999999"
"9999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: 由于对象已存在，下列语句失败:
"CREATE SEQUENCE "VOF_JJMXLSH" MINVALUE 1 MAXVALUE 9999999999999999999999999"
"99 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: 由于对象已存在，下列语句失败:
"CREATE SEQUENCE "VOF_JJWTLSH" MINVALUE 1 MAXVALUE 9999999999999999999999999"
"99 INCREMENT BY 1 START WITH 61 CACHE 20 NOORDER NOCYCLE"
IMP-00015: 由于对象已存在，下列语句失败:
"CREATE SEQUENCE "VOF_JJWTQRLSH" MINVALUE 1 MAXVALUE 99999999999999999999999"
"9999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: 由于对象已存在，下列语句失败:
"CREATE SEQUENCE "VOF_ZHWTLSH" MINVALUE 1 MAXVALUE 9999999999999999999999999"
"99 INCREMENT BY 1 START WITH 61 CACHE 20 NOORDER NOCYCLE"
IMP-00015: 由于对象已存在，下列语句失败:
"CREATE SEQUENCE "VOF_ZHWTQRLSH" MINVALUE 1 MAXVALUE 99999999999999999999999"


我写的是：
imp system/*****@ora41 file=d:\123.dmp fromuser=**** to user=***

binary

不是说了“对象已存在”吗？原用户下还有这些对象，怎么imp啊

drop user *** cascade，再重建用户，再imp吧

txfy

也可以加入ignore=y参数

btxtguo

加入ignore=y参数还是不行，我的DMP 是这样做EXP SYSTEM/***·ORA OWNER=*** FILE=D：\123.DMP ,那IMP 回去应该怎么写呢？小弟是低手，请教给个完整的IMP 命令。多谢多谢！！！！

feijin

ignore=y 后还是 imp-00015错？？？

btxtguo

是的log如下：
连接到: Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

经由常规路径导出由EXPORT:V09.02.00创建的文件
已经完成ZHS16GBK字符集和AL16UTF16 NCHAR 字符集中的导入
导入服务器使用WE8ISO8859P1字符集 (可能的字符集转换)
. 正在将OFSS2000的对象导入到 GSLAP
IMP-00003: 遇到 ORACLE 错误 1435
ORA-01435: user does not exist
成功终止导入，但出现警告。

zgahj

你在exp 后，如果导回原用户的话，先要把原用户的所有对象删除掉。
否则，会报错，如果加ignore=y的话，会一行一行的校验，太慢。

至于这句：ORA-01435: user does not exist

在导入前，要确定相应的表空间和用户在不在