3 added 73 characters in body
source | link

While creating a common user, any default tablespace, temporary tablespace, or profile specified using the following clauses must exist in all the containers belonging to the CDB:

  • DEFAULT TABLESPACE
  • TEMPORARY TABLESPACE
  • QUOTA
  • PROFILE

  • More

    According to the output you have updated it appears that the PAVEL_DATA tablespace doesn't exist in container number 4.

    Moreover, the CREATE USER or ALTER USER command with DEFAULT TABLESPACE or DEFAULT TEMPORARY TABLESPACE clause may succeed if the default/temporary tablespace specified don't exist on the PDBS which are currently closed. But you may get errors when you try to open or try to connect these newly opened PDBs using the common user you have just created or altered.

    Demonstration:

    SQL> create user c##_sales_hr identified by password default tablespace tbs_sales;
    create user c##_sales_hr identified by password default tablespace tbs_sales
    *
    ERROR at line 1:
    ORA-65048: error encountered when processing the current DDL statement in
    pluggable database ORAPDB1
    ORA-00959: tablespace 'TBS_SALES' does not exist
    
    
    SQL> select tablespace_name, con_id from cdb_tablespaces;
    
    TABLESPACE_NAME                CON_ID
    ------------------------------ ----------
    SYSTEM                         1
    SYSAUX                         1
    UNDOTBS1                       1
    TEMP                           1
    USERS                          1
    TBS_SALES                      1
    SYSTEM                         4
    SYSAUX                         4
    TEMP                           4
    ORAPDB1_TBS1                   4
    MGMT_ECM_DEPOT_TS              4
    
    11 rows selected.
    
    SQL> alter session set container=orapdb1;
    
    Session altered.
    
    SQL> create tablespace tbs_sales datafile '+DATA' size 50M;
    
    Tablespace created.
    
    SQL> conn / as sysdba
    Connected.
    SQL> create user c##_sales_hr identified by password default tablespace tbs_sales;
    
    User created.
    

    While creating a common user, any default tablespace, temporary tablespace, or profile specified using the following clauses must exist in all the containers belonging to the CDB:

  • DEFAULT TABLESPACE
  • TEMPORARY TABLESPACE
  • QUOTA
  • PROFILE

  • More

    According to the output you have updated it appears that the PAVEL_DATA tablespace doesn't exist in container number 4.

    Moreover, the CREATE USER or ALTER USER command with DEFAULT TABLESPACE or DEFAULT TEMPORARY TABLESPACE clause may succeed if the default/temporary tablespace specified don't exist on the PDBS which are currently closed. But you may get errors when you try to open or try to connect these newly opened PDBs using the common user you have just created or altered.

    Demonstration:

    SQL> create user c##_sales_hr identified by password default tablespace tbs_sales;
    create user c##_sales_hr identified by password default tablespace tbs_sales
    *
    ERROR at line 1:
    ORA-65048: error encountered when processing the current DDL statement in
    pluggable database ORAPDB1
    ORA-00959: tablespace 'TBS_SALES' does not exist
    
    
    SQL> select tablespace_name, con_id from cdb_tablespaces;
    
    TABLESPACE_NAME            CON_ID
    ------------------------------ ----------
    SYSTEM                  1
    SYSAUX                  1
    UNDOTBS1                1
    TEMP                    1
    USERS                   1
    TBS_SALES               1
    SYSTEM                  4
    SYSAUX                  4
    TEMP                    4
    ORAPDB1_TBS1                4
    MGMT_ECM_DEPOT_TS           4
    
    11 rows selected.
    
    SQL> alter session set container=orapdb1;
    
    Session altered.
    
    SQL> create tablespace tbs_sales datafile '+DATA' size 50M;
    
    Tablespace created.
    
    SQL> conn / as sysdba
    Connected.
    SQL> create user c##_sales_hr identified by password default tablespace tbs_sales;
    
    User created.
    

    While creating a common user, any default tablespace, temporary tablespace, or profile specified using the following clauses must exist in all the containers belonging to the CDB:

  • DEFAULT TABLESPACE
  • TEMPORARY TABLESPACE
  • QUOTA
  • PROFILE

  • More

    According to the output you have updated it appears that the PAVEL_DATA tablespace doesn't exist in container number 4.

    Moreover, the CREATE USER or ALTER USER command with DEFAULT TABLESPACE or DEFAULT TEMPORARY TABLESPACE clause may succeed if the default/temporary tablespace specified don't exist on the PDBS which are currently closed. But you may get errors when you try to open or try to connect these newly opened PDBs using the common user you have just created or altered.

    Demonstration:

    SQL> create user c##_sales_hr identified by password default tablespace tbs_sales;
    create user c##_sales_hr identified by password default tablespace tbs_sales
    *
    ERROR at line 1:
    ORA-65048: error encountered when processing the current DDL statement in
    pluggable database ORAPDB1
    ORA-00959: tablespace 'TBS_SALES' does not exist
    
    
    SQL> select tablespace_name, con_id from cdb_tablespaces;
    
    TABLESPACE_NAME                CON_ID
    ------------------------------ ----------
    SYSTEM                         1
    SYSAUX                         1
    UNDOTBS1                       1
    TEMP                           1
    USERS                          1
    TBS_SALES                      1
    SYSTEM                         4
    SYSAUX                         4
    TEMP                           4
    ORAPDB1_TBS1                   4
    MGMT_ECM_DEPOT_TS              4
    
    11 rows selected.
    
    SQL> alter session set container=orapdb1;
    
    Session altered.
    
    SQL> create tablespace tbs_sales datafile '+DATA' size 50M;
    
    Tablespace created.
    
    SQL> conn / as sysdba
    Connected.
    SQL> create user c##_sales_hr identified by password default tablespace tbs_sales;
    
    User created.
    
    2 added 1786 characters in body
    source | link

    While creating a common user, any default tablespace, temporary tablespace, or profile specified using the following clauses must exist in all the containers belonging to the CDB:

  • DEFAULT TABLESPACE
  • TEMPORARY TABLESPACE
  • QUOTA
  • PROFILE

  • More

    According to the output you have updated it appears that the PAVEL_DATA tablespace doesn't exist in container number 4.

    Moreover, the CREATE USER or ALTER USER command with DEFAULT TABLESPACE or DEFAULT TEMPORARY TABLESPACE clause may succeed if the default/temporary tablespace specified don't exist on the PDBS which are currently closed. But you may get errors when you try to open or try to connect these newly opened PDBs using the common user you have just created or altered.

    Demonstration:

    SQL> create user c##_sales_hr identified by password default tablespace tbs_sales;
    create user c##_sales_hr identified by password default tablespace tbs_sales
    *
    ERROR at line 1:
    ORA-65048: error encountered when processing the current DDL statement in
    pluggable database ORAPDB1
    ORA-00959: tablespace 'TBS_SALES' does not exist
    
    
    SQL> select tablespace_name, con_id from cdb_tablespaces;
    
    TABLESPACE_NAME            CON_ID
    ------------------------------ ----------
    SYSTEM                  1
    SYSAUX                  1
    UNDOTBS1                1
    TEMP                    1
    USERS                   1
    TBS_SALES               1
    SYSTEM                  4
    SYSAUX                  4
    TEMP                    4
    ORAPDB1_TBS1                4
    MGMT_ECM_DEPOT_TS           4
    
    11 rows selected.
    
    SQL> alter session set container=orapdb1;
    
    Session altered.
    
    SQL> create tablespace tbs_sales datafile '+DATA' size 50M;
    
    Tablespace created.
    
    SQL> conn / as sysdba
    Connected.
    SQL> create user c##_sales_hr identified by password default tablespace tbs_sales;
    
    User created.
    

    While creating a common user, any default tablespace, temporary tablespace, or profile specified using the following clauses must exist in all the containers belonging to the CDB:

  • DEFAULT TABLESPACE
  • TEMPORARY TABLESPACE
  • QUOTA
  • PROFILE

  • More

    According to the output you have updated it appears that the PAVEL_DATA tablespace doesn't exist in container number 4.

    While creating a common user, any default tablespace, temporary tablespace, or profile specified using the following clauses must exist in all the containers belonging to the CDB:

  • DEFAULT TABLESPACE
  • TEMPORARY TABLESPACE
  • QUOTA
  • PROFILE

  • More

    According to the output you have updated it appears that the PAVEL_DATA tablespace doesn't exist in container number 4.

    Moreover, the CREATE USER or ALTER USER command with DEFAULT TABLESPACE or DEFAULT TEMPORARY TABLESPACE clause may succeed if the default/temporary tablespace specified don't exist on the PDBS which are currently closed. But you may get errors when you try to open or try to connect these newly opened PDBs using the common user you have just created or altered.

    Demonstration:

    SQL> create user c##_sales_hr identified by password default tablespace tbs_sales;
    create user c##_sales_hr identified by password default tablespace tbs_sales
    *
    ERROR at line 1:
    ORA-65048: error encountered when processing the current DDL statement in
    pluggable database ORAPDB1
    ORA-00959: tablespace 'TBS_SALES' does not exist
    
    
    SQL> select tablespace_name, con_id from cdb_tablespaces;
    
    TABLESPACE_NAME            CON_ID
    ------------------------------ ----------
    SYSTEM                  1
    SYSAUX                  1
    UNDOTBS1                1
    TEMP                    1
    USERS                   1
    TBS_SALES               1
    SYSTEM                  4
    SYSAUX                  4
    TEMP                    4
    ORAPDB1_TBS1                4
    MGMT_ECM_DEPOT_TS           4
    
    11 rows selected.
    
    SQL> alter session set container=orapdb1;
    
    Session altered.
    
    SQL> create tablespace tbs_sales datafile '+DATA' size 50M;
    
    Tablespace created.
    
    SQL> conn / as sysdba
    Connected.
    SQL> create user c##_sales_hr identified by password default tablespace tbs_sales;
    
    User created.
    
    1
    source | link

    While creating a common user, any default tablespace, temporary tablespace, or profile specified using the following clauses must exist in all the containers belonging to the CDB:

  • DEFAULT TABLESPACE
  • TEMPORARY TABLESPACE
  • QUOTA
  • PROFILE

  • More

    According to the output you have updated it appears that the PAVEL_DATA tablespace doesn't exist in container number 4.