Where .dmp file is restored after import in oracle?
Thanks. I have imported dmp file by following steps..

Command to open SQLPLUS

In Command Prompt:
C:> sqlplus / as sysdba



Clear Screen:

SQL> Clear Screen



1- First create a new user by

SQL&gt; Create user TestUser1 identified by test; -- (test is password)


2- Grant Privilages to new created user TestUser

SQL&gt; Grant dba, IMP_FULL_DATABASE, EXP_FULL_DATABASE to TestUser;


Optional:

You can check which users have the above three grants

SET lines 100 --May not work
COL privilege FOR a50 -- May not work
SELECT grantee, granted_role, default_role 
FROM dba_role_privs 
WHERE granted_role IN ('DBA', 'EXP_FULL_DATABASE', 'IMP_FULL_DATABASE') 
ORDER BY 1,2; -- May not work


3- Check TableSpace for this newly created user

SQL&gt; select * from dba_users

Note: here you will see that the default DEFAULT_TABLESPACE for TESTUSER is USERS


4- Create a new TableSpace for this newly created user "TestUser"

SQL&gt; CREATE TABLESPACE tbs_testuser1
    DATAFILE 'tbs_testuser1.dat' 
        SIZE 256M REUSE
        AUTOEXTEND ON NEXT 256M MAXSIZE 2048M

    ONLINE;


5- Now Connect this newly created tablespace  'tbs_testuser1' to 'testuser1'.

SQL&gt;  ALTER USER TESTUSER1 default tablespace tbs_testuser1 quota unlimited on tbs_testuser1;


6- Check whether your 'tbs_testuser1' tablespace is connected to user or not.

SQL&gt; select * from dba_users


7- In command prompt:

c:\&gt;imp system/password file=File Path.dmp log=LOGFileName.log fromuser = &lt;UserName of User from which file is imported&gt; touser=testuser1