Hello,
I would be very grateful if you gave me an advice.
I installed APEX 19.2 and Oracle 18c XE. APEX works fine except I dont have access to the APEX data from SQL Plus or SQL Developer.
As an example, I created a schema and wordspace 'demo7' and the table 'Images'.
The result in SQL Plus:
SQL> select * from all_users where username='demo7';
no rows selected
SQL> alter session set current_schema=apex_190200;
ERROR:
ORA-01435: user does not exist
In the installation logs ( https://1drv.ms/u/s!AmE9taTPnkR9gfRAMUOSa2Vgq_srJQ?e=89Zupg ) it is written that APEX schema is 'APEX_190200'. In SQL Plus it is not visible either.
What is more strange is that if I create a schema with tables in SQL Plus and grant necessary priviledges, it is not visible in APEX in new workspace creation dialog.