使用impdp入库,报错信息如下,baidu,谷歌了都没找到比较合适的答案。Import: Release 10.2.0.1.0 - 64bit Production on Friday, 27 April, 2012 11:13:24Copyright (c) 2003, 2005, Oracle. All rights reserved.
;;;
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Master table "SUPERSTAR"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded
Starting "SUPERSTAR"."SYS_IMPORT_SCHEMA_01": SUPERstar/********@SUPERbase directory=zlxtemp DUMPFILE=SUPERzlx.dmp SCHEMAS=SUPERstar logfile=SUPERzlx.log
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER:"SUPERSTAR" already exists
Processing 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/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "SUPERSTAR"."SUPER_SPATIAL_SEARCH_0301" 2.927 GB 28213786 rows
. . imported "SUPERSTAR"."EPGIS_CLUSTER_SYN$" 591.9 MB 57340 rows
ORA-31693: Table data object "SUPERSTAR"."SUPERGRAPHY_SUPER_AU_DISHIMING":"A" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-26065: check constraint cannot reference column, SYS_NC00008$, in direct path load
ORA-31693: Table data object "SUPERSTAR"."SUPERGRAPHY_SUPER_AU_GUODAO":"A" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-26065: check constraint cannot reference column, SYS_NC00008$, in direct path load
ORA-31693: Table data object "SUPERSTAR"."SUPERGRAPHY_SUPER_AU_ROAD":"A" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-26065: check constraint cannot reference column, SYS_NC00008$, in direct path load
. . imported "SUPERSTAR"."ATT_PT_VIPO" 23.16 MB 81843 rows
ORA-31693: Table data object "SUPERSTAR"."STATION_SUPER_ST_LINK":"A" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-26065: check constraint cannot reference column, SYS_NC00008$, in direct path load
;;;
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Master table "SUPERSTAR"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded
Starting "SUPERSTAR"."SYS_IMPORT_SCHEMA_01": SUPERstar/********@SUPERbase directory=zlxtemp DUMPFILE=SUPERzlx.dmp SCHEMAS=SUPERstar logfile=SUPERzlx.log
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER:"SUPERSTAR" already exists
Processing 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/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "SUPERSTAR"."SUPER_SPATIAL_SEARCH_0301" 2.927 GB 28213786 rows
. . imported "SUPERSTAR"."EPGIS_CLUSTER_SYN$" 591.9 MB 57340 rows
ORA-31693: Table data object "SUPERSTAR"."SUPERGRAPHY_SUPER_AU_DISHIMING":"A" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-26065: check constraint cannot reference column, SYS_NC00008$, in direct path load
ORA-31693: Table data object "SUPERSTAR"."SUPERGRAPHY_SUPER_AU_GUODAO":"A" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-26065: check constraint cannot reference column, SYS_NC00008$, in direct path load
ORA-31693: Table data object "SUPERSTAR"."SUPERGRAPHY_SUPER_AU_ROAD":"A" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-26065: check constraint cannot reference column, SYS_NC00008$, in direct path load
. . imported "SUPERSTAR"."ATT_PT_VIPO" 23.16 MB 81843 rows
ORA-31693: Table data object "SUPERSTAR"."STATION_SUPER_ST_LINK":"A" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-26065: check constraint cannot reference column, SYS_NC00008$, in direct path load
解决方案 »
- Procedure 能直接使用傳入的 ('ID1','ID2','ID3','ID4')作為一個整的字符進行 IN 的查詢么?
- 在linux下,启动oracle,提示LRM-00109: could not open parameter file.. initorcl.ora文件
- 一道题目 大家来帮忙
- ORACLE 10G调优要设置些什么参数
- oracle 怎么查询唯一索引
- 用同表中的某些记录更新其他记录
- 大虾们 小弟求救 oracle xe 创建数据库问题
- 关于如何配置oracle服务监听
- 请问!
- oracle时间查询的问题
- XP安装Oracle 10g时出现无法初始化OCR
- 我想将数据库从9201升到9206,能否装好9206后,将数据文件直接拷过去,就算完。
http://topic.csdn.net/u/20090909/15/04aa3b28-3685-41aa-b3cf-9bd8a87c8577.html
一样,但是没有答案呢
检查这个表上的约束