Oracle Database - Import (imp)

Card Puncher Data Processing


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)


imp help=y


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


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


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


Create a log file generated with the LOG parameter.


Discover More
Data Pump Sqldeveloper
Oracle Database - Data Pump Import (impdp)

The import utility of data pump In order to use Data Pump, the database administrator must create a directory object and grant privileges to the user on that directory object. If a directory...
Card Puncher Data Processing
Oracle Database - Export Utility (exp)

Client Export utility. See The Export utility supports four modes of operation: Full: Exports a full database. Only users with the EXP_FULL_DATABASE role can use this mode. The FULL parameter...

Share this page:
Follow us:
Task Runner