Hello Experts-
I am a bit confused here and hope someone can explain the following behavior.
- Expdp with SCHEMA=SCHEMA_NAME
- Impdp with REMAP_SCHEMA=SCHEMA_NAME:NAME2
Import is successful and through sqlplus on the database server I was able to verify the NAME2 credentials i.e. able to connect using the password of schema_name.
Question: However I am unable to connect (getting the invalid username /password error) when I try connecting using the same credentials through TOAD.
After alter user NAME2 identified by <password>; I was able to connect via TOAD.
Why should I perform an alter user to make this work if impdp will grab the credential info. from export ?