导入oracle数据库dmp时,报错ORA-39083: Object type
我的问题:
Import: Release 10.2.0.3.0 - Production on Tuesday, 14 December, 2010 13:31:31
Copyright (c) 2003, 2005, Oracle. All rights reserved.
;;;
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
Master table "NEW"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "NEW"."SYS_IMPORT_FULL_01": new/********@orcl DIRECTORY=DATA_PUMP_DIR DUMPFILE=xxx.dmp REMAP_SCHEMA=old:new REMAP_TABLESPACE=old:new;
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER:"OLD" already existsProcessing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
ORA-39083: Object type TABLE failed to create with error:
ORA-00959: tablespace 'NEW;' does not exist
之前已经导入往一个tablespace了一个版本的dump , 它其中有含有Object type USER:"OLD".
现在唯一的办法是把以前的版本Object type USER:"OLD"的dump及空间表都删除,然后重建,再导入。
但是现在的问题是,我想保留以前的版本,新旧两个表空间我都想要,可是我再导入这个升级的dump时(包含OLD)
PS:第二次已经创建好表空间NEW后才运行命令的。
cmd:
impdp username/password@orcl DIRECTORY=DATA_PUMP_DIR DUMPFILE=xxx.dmp MAP_SCHEMA=old:new REMAP_TABLESPACE=old:new
请教高手!!!
PS:在网上找了遍,也没找到问题的根源~