ORA-26032 impdp (Index organized table)
Iam performing a export and an import in a 12 C source and destination database. I have given the commands I have used. One particular table shows as exported and imported successfully but upon querying the table I see that no records are available.
select * from CISADM.CI_ACCT_APAY_K - no records in destination.
*** exp par file ********************
DIRECTORY=DMTDATA
REUSE_DUMPFILES=Y
COMPRESSION=ALL
PARALLEL=32
METRICS=YES
KEEP_MASTER=Y
LOGFILE=DMTLOG:DMT_data.4.exp.log
DUMPFILE=DMT_data.4.%u.dmp
TABLES=CISADM.CI_ACCT_APAY_K
QUERY=CISADM.CI_ACCT_APAY_K:"inner join DMT.D000000109 X on ACCT_APAY_ID = X.\"acct_apay_id\" AND ENV_ID = X.\"env_id\""