Search code examples
oracle-databaseoracle-apex

Oracle Apex doesn't show existing schema


I have a problem with connecting data from my local oracle user schema (USERS table space) and apex workplace. Could you adivise how I can connect apex workplace with my existing schema? It looks like APEX uses its own table space and ignores my schemas.

Here are my screenshots: SQL Developer screen Creating a new workspace screen

Forgot one significat thing to mention: schema Pavel in Apex and schema Pavel in SQL Developer are different. Tables, which are created in the Apex in schema Pavel, are not seen in SQL Developer.

No apex user screen

apex create workplace and new schema dialog (different table space), the schema is not visible in sql developer


Solution

  • The problem was in misunderstanding oracle database architecture. The APEX data was stored in the pluggable database, while the default connection in SQL Plus was to the root container cdb$root.

    alter session set container = XEPDB1;