Search code examples
oracle-databaseoracle-apex

On Oracle Apex, how to create multiple database Schema's on the same Workspace using the free version


Using the free package on Oracle Apex (Oracle Application Express), using the online version (not on-premises), hosted on:

https://apex.oracle.com/

Is it possible to create multiple database schema's in a database? This is for the FREE online version.

For example, create a table called [finance].[t_users], where the schema is called [finance].

According to the documentation, this is possible but maybe the free version does not allow this ?

Multiple schemas are essential as the database grows, requiring a separation of logical namespaces via schemas.


Solution

  • Yes, You can create another schema under the same workspace by raising a Service Request.

    enter image description here

    Provide the schema name and submit the request.

    enter image description here Once approved you can see multiple schema's under the Same workspace. Something like below.

    enter image description here