How to import oracle dump file .dmp ?

On: Thursday, February 13, 2014 By: Azhar Mulla 3 comments

How to use import database in oracle using imp utility ?

1.       Create the target user first

SQL> create user supplier2 identified by trpass123 default tablespace users quot

a unlimited on users;

User created.

2.       Provide necessary privillages to user

SQL> grant connect, create session, imp_full_database to supplier2;

Grant succeeded.

3.       Finally importing dump file

C:\Documents and Settings\Admin>imp supplier2/trpass123@orcl file=D:\SUPPLIER2\SUPPLIER2.dmp  full=Y

Here is what it looks like. Don’t use any ‘ or other special characters for file name

Microsoft Windows XP [Version 5.1.2600]

(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Admin>sqlplus

SQL*Plus: Release 11.1.0.6.0 - Production on Thu Feb 13 09:42:07 2014

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Enter user-name: sys as sysdba

Enter password:

Connected to:

Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create user supplier2 identified by trpass123 default tablespace users quot

a unlimited on users;

User created.

SQL> grant connect, create session, imp_full_database to supplier2;

Grant succeeded.

SQL>

 Now run the below utility in command prompt.

C:\Documents and Settings\Admin>imp supplier2/trpass123@orcl file=D:\SUPPLIER2\S

UPPLIER2.dmp  full=Y