错误:
ORA-31693: 表数据对象 "MW_APP"."FJ5W_FZ_JMD_S":"A" 无法加载/卸载并且被跳过, 错误如下:
ORA-02354: 导出/导入数据时出错
ORA-26065: 在直接路径加载中, 检查约束条件不能引用列 SYS_NC00008$ 注释:导入的是一个分区表,oracle10.2.0.2.0, impdp方式导入的查找到的解决方案是:Oracle Error : ORA-26065: check constraint cannot reference column, string, in direct path load Cause: An enabled check constraint was found on a column stored as a lob.Action: Either disable the check constraint before loading the table data * using the direct path mode, or use the conventional path mode * instead.
但是我还是看不懂,请问大侠们怎么解决啊?
ORA-31693: 表数据对象 "MW_APP"."FJ5W_FZ_JMD_S":"A" 无法加载/卸载并且被跳过, 错误如下:
ORA-02354: 导出/导入数据时出错
ORA-26065: 在直接路径加载中, 检查约束条件不能引用列 SYS_NC00008$ 注释:导入的是一个分区表,oracle10.2.0.2.0, impdp方式导入的查找到的解决方案是:Oracle Error : ORA-26065: check constraint cannot reference column, string, in direct path load Cause: An enabled check constraint was found on a column stored as a lob.Action: Either disable the check constraint before loading the table data * using the direct path mode, or use the conventional path mode * instead.
但是我还是看不懂,请问大侠们怎么解决啊?
ALTER TABLE table_name disable CONSTRAINT constraint_name;从网上搜到的,和你一样的问题..http://forums.oracle.com/forums/thread.jspa?threadID=433406I had the same error message when I tried to import previously exported spatial data. The table is created but no data imported. We could resolve the problem by setting the spatial column (before exporting it) to have no check constraint not null.
Then the import functioned without a problem. Actually this is just a workaround which helped me to export and import spatial data. We would like to keep a check constraint not null for the spatial column.
ALTER TABLE DISABLE CONSTRAINT 约束名;约束名从表user_constraints表中找SELECT * FROM USER_CONSTRAINTS WHERE TABLE_NAME='FJ5W_FZ_JMD_S'