ORA-01917

Error 'ORA-01917: user or role 'PSQA' does not exist' when importing Controller Oracle database.
ErrorI am trying to import schema into Oracle database-12c, using a command similar to the following:
imp system/password@databasename file=exp_SOURCEUSERNAME.dmp log=DESTINATION_USERNAME-imp.log
fromuser=SOURCEUSERNAME touser=DESTINATION_USERNAME
Receives below error message.

1.       IMP-00017: following statement failed with ORACLE error 1917:

 "GRANT SELECT ON "ABC_APL_PROFILE_MST" TO "PSQA""

IMP-00003: ORACLE error 1917 encountered

ORA-01917: user or role 'PSQA' does not exist.

Cause

The environment from where the original backup (export / .DMP) file was created is using the (optional) Oracle feature which creates additional grants on objects in the Controller schema.

Solution

Delete the schema, then re-create a blank schema. Finally, import the user (into the new schema) but this time use the optional switch:

grants=no.

Modify your import script, to something similar to:

imp system/password@databasename file=exp_SOURCEUSERNAME.dmp log=DESTINATION_USERNAME-imp.log fromuser=SOURCEUSERNAME touser=DESTINATION_USERNAME grants=no

Issue resolved.