Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

creating separate Dev. / Prod. environment using multiple PDB's

SmithJohn45Apr 23 2025 — edited Apr 23 2025

how to setup and handle dev/prod (separate) environments using multiple PDB's, please guide

  1. a PDB for all database level stuffs like Schema
  2. a PDB for all Restful API's for above Schema

note: currently I am using a Single PDB for both

is it require to install Oracle Apex in both PDB's separately OR how to use single installation?
please guide for this (I am currently using a Single PDB for both)
actual app is in Laravel and there are 2 apps currently EDU(cation) & HR
what are the necessary steps/things which should be implemented?

how to create, assign permissions, access database objects and data, DML operations etc.

please also guide and help for the things I have don't know or ignored to ask as per my little knowledge/experience.

with kind regards

Comments
Post Details
Added on Apr 23 2025
5 comments
246 views