Context: 2 DBs in ORACLE Cloud (free) account, version 21c and version 19c 1 ORACLE 23c instance in Linux VM instance running on a desktop computer.
- Doing expdp and impdp of a specific schema from home computer instantclient_19_8 installation, between the 2 cloud instances (from 21 to 19 version) works without problem (using SCHEMA mode thus),
- then downloading the 2 dmp files with cURL, into the folder shared with the Linux VM
- and then move them to the DATA_PUMP_DIR of the ORACLE 23c instance
- and doing another impdp locally in the VM, fails with ORA-39246.
I generated the trace file (trace=1ff0300) and there is no data corruption reported, just this error as if the dmp set was incomplete while there are only 2 dmp files, and they are both referenced in the 2 trace files.
The expdb of the Cloud is done with ADMIN account, and the impdp on VM 23c is done using SYSTEM. The impdp on VM using a remapping of the DATA tablespace to USERS one.
I also tested with a newly created DATA tablespace w/o remapping but also without success.
Does somebody have any idea - steps to accomplish - to get a better diagnostic of the root cause?
I also loaded the schema from SQL files and then run expdp/impdp locally and of course this works, problem only when using the DMPs downloaded from the Cloud storage.
(all these are used for testing purposes only, so nothing dramatic)