2
votes

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

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.

1
Although apex.oracle.com is free, it is not for production use (not sure if that's what you're doing, just a heads up). However, Oracle now has a free tier in its public cloud which can be used for production: oracle.com/cloud/free That includes two free databases which include APEX. You will get a lot more space too! Check out this video: youtube.com/watch?v=kOn3HdoSs6sDan McGhan
If my answer below helped you to solve your problem, I would appreciate if you can mark the answer as correct. Thanks! @Rax HOW DO I ACCEPT AN ANSWERArun Palanisamy

1 Answers

3
votes

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