When I try to impdp via database link IOT tables fails. The failing SQL is Failing sql is:
CREATE TABLE "MYSCHEMA"."MY_IOT" ("DATE_COL" DATE, "VARCHAR_COL" VARCHA
R2(20 BYTE), "TS_COL" TIMESTAMP (6), CONSTRAINT "XPK_
MY_IOT" PRIMARY KEY ("DATE_COL") ENABLE) ORGANIZATION INDEX NONEP
CTFREE 0 INITRANS 2 MAXTRANS 255 LOGGING TABLESPACE "RCDW_CONTROL_DAT" PCTTHRES
HOLD 50
Somehow, “NONEPCTFREE 0” is part of the failing sql, and that causes the error observed.
impdp ran on Oracle 23c Free Version 23.3.0.23.09. sourcedb database link points to Oracle 19c Enterprise 19.19
impdp api parameters used:
hdl := DBMS_DATAPUMP.OPEN('IMPORT', 'TABLE', 'sourcedb', NULL, NULL);
DBMS_DATAPUMP.SET_PARAMETER(hdl, 'TABLE_EXISTS_ACTION', 'SKIP');
dbms_datapump.data_filter(handle=>hdl, name=>'INCLUDE_ROWS', value=>0);
dbms_datapump.metadata_filter(handle=>hdl, name=>'EXCLUDE_PATH_LIST', value=>'''STATISTICS'',''INDEX'',''REF_CONSTRAINT'',''CONSTRAINT''');
dbms_datapump.metadata_filter(handle=>hdl, name=>'SCHEMA_LIST', value=>'''MYSCHEMA''');
dbms_datapump.metadata_filter(handle=>hdl, name=>'NAME_LIST', value=>'''MY_IOT''');
dbms_datapump.metadata_transform(handle=>hdl, name=>'STORAGE', value=>0);
dbms_datapump.metadata_transform(handle=>hdl, name=>'TABLE_COMPRESSION_CLAUSE', value=>'NONE');
dbms_datapump.metadata_transform(handle=>hdl, name=>'SEGMENT_CREATION', value=>0);
Have anyone else encountered this issue?