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.
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.continue reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.continue reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.