Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
When importing with Data Pump, errors occur as follows due to the creation of the relevant dump file with the traditional export (exp) command.
1 2 3 | ORA-39001: invalid argument value ORA-39000: bad dump file specification ORA-39143: dump file "/u01/backup/export/orcl.dmp" may be an original export dump file |
To avoid the error, the import operation should be performed using the traditional import command. The problem will not occur when importing with a command similar to the following.
1 | imp <user>/<password> file=orcl.dmp ignore=y full=y indexes=n statistics=none constraints=n log=orcl_imp.log grants=n |
