importing a.dmp file into empty oracle 9i

Answer 1

copy mmsd2kstalin.dmp file to c:\


SQL>CONN SYSTEM/MANAGER

SQL>CREATE USER MMS IDENTIFIED BY MMS;
SQL>GRANT CONNECT,RESOURCE,IMP_FULL_DATABASE TO MMS;
SQL>CONN MMS/MMS

SQL>HOST
.....\BIN\IMP

MMS/MMS

EXPDATA.DMP      C:\mmsd2kstalin.dmp




YES  (for entire file)


exit

------------------------

copy PROJECT2345.fmb to c:

-----------
sql> mms/mms
sql>update USERS2  
    set USERID         ='WAEL',
        USERPWD    ='WAEL'
    where USERID  ='vir22';

sql>update USER_ROLE2      
    set USERID    ='WAEL';
  
sql> commit;
--------------------------------------------