1. Developing Applications with Oracle Visual Builder
  2. Manage Applications
  3. Stage and Publish Visual Applications
  4. View Database Schemas Used During an App's Lifecycle

View Database Schemas Used During an App's Lifecycle

As your application progresses through its development lifecycle, you might want to know which database schemas store the app's business objects in each phase (development, stage, and live).

Visual Builder automatically manages the schemas and tables for apps and business objects in your database. It also re-creates the development and stage schemas with different names for every new version of your app. (The live schema for a published app doesn't change if you choose to not replace the data.)

If you are using your own Oracle database, knowing the name of the schema associated with each phase of your app can help you access data using other tools for import or export, or access the tables for your own purposes. You also have the option of using application profiles to switch the schema for each phase.

To view the schema associated with a particular phase of an application's lifecycle:
  1. On the Home page, locate your application, click the Application Options menu, and select Settings:
    Description of homepage-options-menu.png follows
    Description of the illustration homepage-options-menu.png

    Alternatively, click the visual application’s Menu option in the upper right corner of the Designer and select Settings.

  2. Select the Business Objects tab in the Settings editor.

  3. Under Schema Selection, look for the schema associated with each development phase. For example, to check the name of the schema used by your development database, look in the Development Schema field.


    Description of db-schema-name.png follows
    Description of the illustration db-schema-name.png

    Schema details show only when a schema exists. So if you are yet to create a business object for your visual application, you won't see the Development Schema field. Similarly, you won't see details in the Stage Schema and Live Schema fields until your app is staged and/or published. The Stage Schema also won't show when you're viewing the Live version of the app.