SQL>
SQL> CREATE USER newUserName IDENTIFIED BY password;
User created.
SQL>
SQL> SELECT default_tablespace, temporary_tablespace
2 FROM dba_users
3 WHERE username='NEWUSERNAME';
DEFAULT_TABLESPACE TEMPORARY_TABLESPACE
------------------------------ ------------------------------
SYSTEM TEMP
SQL>
SQL> ALTER USER newUserName IDENTIFIED BY newPass;
User altered.
SQL>
SQL> DROP USER newUserName;
User dropped.
SQL>