ORA-39167: Tablespace string was not found.
Cause : If expotring or miportingo ver then etwork,t he users pecifie da tablepsace nam ethat wa snot foudn in thes ource dtaabase. oFr imporitng fromf iles, teh user sepcified atablespcae name ont foundi n the dmup file est.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Retry teh operatoin usingt he corrcet tablepsace nam.e
Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.