Error ORA-01920 (conflicts whit another user) but user doesn't exist
985859Jan 18 2013 — edited Jan 20 2013I have a problem, of course! (Excuse me for my english.)
I have a DB 10g and exported 4 users from there. I imported in a new DB in a specific order: User1, user2, user3, user4 because it had synonyms, etc.
The User2 has several synonym for tables from User1. Cause a export error I had to drop the User1, but I didn't drop with cascade.
When I attempted create the User1 again I got an error:
ORA-01920: user name User1 conflicts with another user or role name
but this user doesn't exist anymore!
But If I query in dba_users table the User1 appears.
Concluding, I can't create the User1 again and I can't really drop the User1.
What happenned?
I need use the same user name.
Thanks
Edited by: 982856 on Jan 18, 2013 7:04 PM