Oracle Database - Import (imp)

About

Import utility that can work on a remote computer (not on the server as Oracle Database - Data Pump - (Export|Import) Utilities).

See Oracle Database - Export Utility (exp)

Articles Related

Help

imp help=y

Lang

The Export utility always exports user data, including Unicode data, in the character sets of the Export server. (Character sets are specified at database creation.) If the character sets of the source database are different than the character sets of the import database, then a single conversion is performed to automatically convert the data to the character sets of the Import server.

How to

Only one mode (TABLES, FROMUSER, or FULL) can be specified

List the content of a file

imp user/pwd@db FILE=myFile.DAT FROMUSER=userSource TOUSER=userTarget SHOW=Y

Full Import

imp dq_src/dq_src@<ORCL or your database service name> file=<PATH>\dq_src.dmp full=y

Specifies whether to import the entire export dump file.

Copy user schema to an other

imp SH_TARGET/SH_TARGET FROMUSER=SH TOUSER=SH_TARGET

This parameter is relevant only to users with the IMP_FULL_DATABASE role.

Support

ORA-02304: invalid object identifier literal

Create your own type before import.
Set the TOID_NOVALIDATE parameter
And import again

IMP-00015: following statement failed because the object already exists:
 "CREATE TYPE "MAX_SQL_VC2_NTT" TIMESTAMP '2014-12-09:11:20:45' OID 'CB14DC0E"
 "EC4E031FE040007F01002AC4'                                                  "
 "            is table of varchar2(4000);"
. . skipping TOID validation on type NICOLAS.MAX_SQL_VC2_NTT

Diagnostic

Create a log file generated with the LOG parameter.