ORA-02155
Tried to set the default permanent tablespace for an user, but it failed with ORA-02155.
SQL> alter user hr default tablespace;
alter user hr default tablespace
*
ERROR at line 1:
ORA-02155: invalid DEFAULT tablespace identifier
ORA-02155 means that a tablespace identifier is missing from the statement at the position where it points out in the error message.
To correct ORA-02155, we should provide a valid tablespace name which conforms to Database Object Naming Rules.
SQL> alter user hr default tablespace tbs_01;
User altered.
We fixed it.