oracleoracle12cpluggable-database

I do not visualize the changes I make in sqlplus in SQL Developer in an oracle 12c database, which I am raising with docker

Good afternoon, I am working with docker and an oracle 12c database, the official image found in the docker hub, the question is that I am testing creating a user from the SQL Plus, and when I am going to verify in the SQL developer, Note that the changes executed with the SQL Plus are not displayed in the SQL Developer, even having made the respective console commit (as shown in the image)

Creation of the user, commit and the current user of the session:

enter image description here

Then checking in the SQL Developer:

enter image description here

The configuration of the SQL Developer, with the port and ip of the host (not of the container) and the user of the session:

enter image description here

What can I need to configure? I've been looking for a solution for hours and nothing

Solution

  • container should be set before creating a user for a pluggable DB :

    SQL> ALTER SESSION SET CONTAINER = orclpdb1;

    and display whether connected to that container : 

    SQL> SHOW CON_NAME

CON_NAME
------------------------------
ORCLPDB1

    and finally create concerned user :

    SQL> CREATE USER cesar IDENTIFIED BY prueba123 [CONTAINER=CURRENT];

    square bracketed part is optional