I am trying to import one dump file to an Oracle database, but am getting the following error:
Warning: objects were exported by HRMSLIVE, not by you IMP-00003: oracle error 1435 encountered ORA-1435: user does not exist
I used the following code in the command prompt:
imp hrms1/hrms1@hrmsnew file=""E:kiranhrms.dmp" fromuser=hrmslive touser=hrms1;
In order to be able to use the FROMUSER/TOUSER parameters, the user performing the import must have been granted the IMPORT_FULL_DATABASE role. Without this role, you will receive the errors above. Either grant this role to the HRMS1 user or perform the import as the HRMSLIVE user.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.