While assigning default tablespace for a user, got an ORA-12910 error.


As the error says, we can’t set a temporary tablespace as default tablespace for a user. We can only set as a PERMANENT tablespace.
We can get the type of tablespace by using below query.

So just use a tablespace with PERMANENT type.