Oracle Visual Builder comes with a built in database that is used to store data for your business obejcts (and your apps metada too). That DB, however, is limited to 5GB in size and also doesn’t enable you to access the data in the objects using regular SQL. Luckily, you can point Visual Builder to use another Oracle cloud database including the new Oracle Autonomous Transaction Processing (ATP) database – which will give you more space and direct SQL access to the objects VB creates. You can even use a Free Forever Oracle ATP which will get you 20GB of storage for free. In the demo below we show you the steps to take to do this switch.
The switch over is quite simple and is done with a simple two step wizard in your VB instance settings. You’ll need to provide the connection information to your DB – for an ATP DB this would include the wallet.zip file with the connection info. VB will then do the work for you switching to use the new instance. More info on the process is in our Visual Builder Administration Guide.
One additional step you will need to do in the wizard is to backup (export) any apps you want to keep around. Read the complete article here.
For regular information become a member in the Developer Partner Community please register here.