ORA-65048 and ORA-00959: tablespace '******' does not exist

error Details :

SQL> alter user C##GGATE default tablespace GGUSER;
alter user C##GGATE default tablespace GGUSER
*
ERROR at line 1:
ORA-65048: error encountered when processing the current DDL statement in
pluggable database ******
ORA-00959: tablespace '******' does not exist

Solution:

we are creating common user and also assign on specific tablespace to it. So we need to create same tablespace on all pluggable database and  then try to create user.

SQL> create tablespace GGUSER
  2  datafile '/u01/app/oracle/oradata/orcl/gguser01.dbf' size 1g;

Tablespace created.

SQL> show con_id;

CON_ID
------------------------------
1
SQL> alter user C##GGATE default tablespace GGUSER;
alter user C##GGATE default tablespace GGUSER
*
ERROR at line 1:
ORA-65048: error encountered when processing the current DDL statement in
pluggable database SALE
ORA-00959: tablespace 'GGUSER' does not exist



SQL> alter session set container=sale;

Session altered.


SQL> create tablespace GGUSER
  2  datafile '/u01/app/oracle/oradata/orcl/sale/gguser01.dbf' size 1g;

Tablespace created.

==> connect to container database

SQL> alter user C##GGATE default tablespace GGUSER;

User altered.

SQL>