Dear All,
We are using Oracle database 11g. we are using EXP to export the dabase schema from development to client machines for implementation. We are exporting the schema with grants and importing to the client specific schema name. The source schema name and the new schema name will differ. Now when we are importing, some tables are importing properly, and after that the message is showing
Importing <source_schema_name>'s objects in to <source_schema_name>
"ALTER SESSION SET CURRENT_SCHEMA = "<source_schema_name>" "
IMP-00003 : Oracle error 1435 encountered
ORA-01435 : user doesnot exist
IMP-00000 : Import terminated unsuccessfully
But the import is working perfectly when the export is done without grants. We tried by creating the source schema name in client db, then some tables are importing to the actual schema, and after some tables, all remaining db objests are importing to the source schema.
What is the reason behind this issue, and is there any solution other than exporting without grant?
Thanks,
Manu.