Help!orcal8.04升级到8.16?

windchill

重建了USR和TEMPORARY表空间，BUT IMP出错：
Export file created by EXPORT:V08.00.04 via conventional path

Warning: the objects were exported by WTADMIN, not by you

import done in WE8ISO8859P1 character set and UTF8 NCHAR character set
import server uses UTF8 character set (possible charset conversion)
export client uses ZHS16GBK character set (possible charset conversion)
export server uses ZHS16GBK NCHAR character set (possible ncharset conversion)
. . importing table             "ACCEPTEDSTRATEGY"          0 rows imported
. . importing table                 "ACCESSPOLICY"         36 rows imported
.....
. . importing table         "ADMINISTRATIVEDOMAIN"         36 rows imported
IMP-00017: following statement failed with ORACLE error 1452:
"CREATE UNIQUE INDEX "ADMINISTRATIVEDOMAIN$NAME" ON "ADMINISTRATIVEDOMAIN" ("
""NAME" )  PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE (INITIAL 32768 NEXT 32"
"768 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1"
" BUFFER_POOL DEFAULT) TABLESPACE "USR" LOGGING"
IMP-00003: ORACLE error 1452 encountered
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
. . importing table         "AFFECTEDACTIVITYDATA"          0 rows imported

这又是为何?求救！！！

Sshark

可以避开这个问题的。
假设你原来的数据库owner是shark，你可以把shark默认的temporary
tablespace指向你喜欢的sharktemptbs
然后把需要备份的表写入parafile的table参数里去
通过exp shark/pass parfile=ulike file=804.dmp备份出来
在8.1.6机器上创建同名Shark账号，同名temporary tablespace
再用imp输出就可以了。