ORA-39083: Object type INDEX failed to create with error:

描述

在利用impdp导入数据报错，报错如下：

Failing sql is:
CREATE INDEX "EHR_TEST_1116"."T_TEMP_CF057895_INDEX" ON "EHR_TEST_1116"."T_TEMP_CF057895" (PCTFREE 10 INITRANS 2 MAXTRANS 255  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "EHR" PARALLEL 4 
ORA-39083: Object type INDEX failed to create with error:
ORA-00936: missing expression

 

提示创建索引错误

解决方案

这是在导入索引过程中报错，需要在原库，查找索引的创建语句，在新的环境创建

查找语句

SET LONG 2000000
SET PAGESIZE 0

select  DBMS_METADATA.GET_DDL('INDEX','T_TEMP_CF057895_INDEX','EHR_TEST_1116') from dual;

 

找到语句在新库执行