There are some Oracle tools and third Party tools that allows Create a User as another one but we still don’t have this possiblity writing just SQL Code
I’d like to have a New Clause “as User” in Create User for example
Create User ... as User ... Identified by ...
this clause have to recover the user definition (default tablespace, temp, profile, etc) and privilegies from the originary user and create a New user with the same definitions and Grant the same privileges