Oracle 12c Create user

1. Open SQL Plus

2. Log on using the system

3. Use Select sys_context ('USERENV ', 'con_name ') from dual; See if the current user is a CDB user or a PDB user

4. Use alter pluggable database PDBORCL Open, open pdb mode

5. Use Alter session set CONTAINER=PDBORCL; switch to pdb

6. Use again at this time Select sys_context ('USERENV ', 'con_name ') from dual; You can switch to the PDB.

7. You can create a user as normal as the previous version.

Note: PDBORCL is using select Con_id,dbid,name,open_mode from V$pdbs; NAME found

At the end of the use of the interface login to pay attention to not the previous SID, but with the service name login

Oracle 12c Create user