CREATING LOCAL USER IN PDB

SQL> alter session set container=PDBTEST2;

Session altered.

SQL> show con_name;

CON_NAME
------------------------------
PDBTEST2

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/data/oracle/oradata/CDBTES/undotbs01.dbf
/data/oracle/oradata/CDBTES/PDBTEST2/system01.dbf
/data/oracle/oradata/CDBTES/PDBTEST2/sysaux01.dbf
/data/oracle/oradata/CDBTES/PDBTEST2/PDBTEST2_users01.dbf

SQL> create user syedpdb2 identified by india123
  default tablespace users
   container=all;;

User created.