My Oracle Support Banner

Visual Builder FAQ - Queries On Tenant Database Configuration (Doc ID 2711424.1)

Last updated on SEPTEMBER 26, 2020

Applies to:

Oracle Integration-OIC
Oracle Visual Builder Studio - Version N/A to N/A
Information in this document applies to any platform.

Purpose

 Common queries on VB Tenant Database Configuration

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
  Q1.  After switching to appropriate database, how will the data be stored and accessed. Will it store the data based on the Stage, Dev and Live mode or only one set of data ?
Please provide relevant links for further reading.
 Q2.  After switching to database, can I remove the tenant database and use the embedded database back in VB ?
 Q3. After configuring the tenant database, as you mentioned there will be separate schemas created for Dev, Stage and Live.  Will these custom schemas be accessible only from Admin or SYS user ?
 Is there any way that we can connect to that custom schema individually and provide access to this schema for other systems, so that they can load the data and the same data can be used in VBCS UI. 
 Q4.   After having custom PL/SQL code in database, can I access it inside in the VBCS application ? Is that possible ? Please share an example if possible.
 Q5.  Can I provide grants from Schema A to VBCSDEV schema and is it possible to access those object in VB ?
 Q6.  Once the tenant database is configured successfully then the custom schemas are created at runtime are like - VB_VB_xxxxxxxxxxx, VB_VB_yyyyyyyyyyy, VB_VB_zzzzzzzzzzz. These custom schemas are actually for only one application but created for DEV, Stage and Live.  I was able to query the data from these schemas using the SYS user.  But, is there any possibility that we can connect to these VB schemas by the standard way of connecting to Database schemas, e.g: by providing username and password ?  If possible, please provide the steps.
Note - I am able to access these schemas from SYS schema and the underlying BOs are also accessible.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.