Was trying to import the data using impdp, but it threw an error ORA-39143.
ORA-39143: dump file "/oradata/recovery_area/full.dmp" may be an original export dump file
This error has already told us the reason why the dump file cannot be used. Because this dump file does not come from data pump, it’s an old-fashioned dump file exported by original or legacy exp utility.
Let’s see the content of ORA-39143
ORA-39143: dump file “string” may be an original export dump file
A dump file was specified for an import operation which appears to have been created using the original export utility. These dump files cannot be processed by the Data Pump import utility.
Try using the original import utility to process this dump file.
Now, you have two choices to avoid ORA-39143. One way is to use original imp utility to import the dump file. The other is to get another dump file which is generated from data pump, i.e. expdp utility.
That is, the original export-import and data pump utilities can’t use each other’s dump files. Because they have their own format.
For transferring your shell scripts from the old exp to the new expdp, Oracle data pump provides a legacy mode to facilitate you to achieve this.
By the way, we normally use system who has enough but not too much privileges to migrate data from one to another, however you can also use expdp AS SYSDBA instead to migrate data.