Using the free package on Oracle Apex (Oracle Application Express), using the online version (not on-premises), hosted on:
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.
Yes, You can create another schema under the same workspace by raising a Service Request.
Provide the schema name and submit the request.
Once approved you can see multiple schema's under the Same workspace. Something like below.