Find the Default Schema Name and Set the Password

The name of the default schema used by Oracle Database Exadata Express Cloud Service is called the Host Schema and can be found from the Oracle Application Express About option. After identifying the schema name, in order to start using it, you need to set the password for the schema.

To find the default schema name:

1. Go to the Oracle Application Express Application Builder home page. See Access Oracle Application Express.
   The Oracle Application Express environment displays.
2. From the Oracle Application Express home page, in the top toolbar, click the Help icon.
   The Help menu displays.

   
   

   
   Description of the illustration apex_about.png

   
   
3. Click About.
   The About Application Express dialog appears including the name of the default schema called Host Schema.

   
   

   
   Description of the illustration host_name.png

   
   
4. Connect with the PDB_ADMIN account, using SQL*Plus, SQLcl or SQL Developer, and issue this statement:

   alter user default_schema_name identified by password

   Where default_schema_name is the name of the default schema you found in previous steps, and password is the password you want to set for the schema.