• Hi,

    You should specify default temporary tablespace for new user.

    You can replicate user from one Oracle database to other Oracle database by specifying encoded password.

    BR,

    Ivan Surovezhin