error encountered when processing the current DDL statement in pluggable database ORAPDB1: the tablespace 'INTERVENTION_TBS' does no exist

Question

I am using oracle 12c and I'm having a little trouble trying to attribute tablespace to a user.

Here is the error I got when processing the current DDL statement in pluggable database ORAPDB1:

the tablespace 'INTERVENTION_TBS' does no exist

Note that the tablespace was created successfully. So could someone suggest a solution please?

For more details I used this syntax query

CREATE USER c##DBAINTERVENTION 
    Identified by interventiondb 
    Default Tablespace INTERVENTION_TBS 
    Temporary Tablespace INTERVENTION_TempTBS;

Answer 1

run the following statements:

alter session set "_ORACLE_SCRIPT"=TRUE;

ALTER USER [username] IDENTIFIED BY [password];