Forum Stats

  • 3,769,801 Users
  • 2,253,023 Discussions
  • 7,875,210 Comments

Discussions

Using DBaaS APEX with PaaS (process and integration)

Chris Maggiulli
Chris Maggiulli Member Posts: 99
edited May 17, 2018 11:03PM in Database Cloud Service

I have a DBaaS instance that I'm using for oracle process cloud (it's oracle bpm essentially). I have data that I want to put in a table and create an APEX rest service. Is it ok to create a table in the same database used underneath by PCS / OIC? Is there anything special I need to do (create a schema only accessible by a certain user,etc)

Answers

  • Arrun Pareek
    Arrun Pareek Member Posts: 133
    edited May 16, 2018 2:01AM

    Hi Chris,

    We have been doing the same thing for our applications on OIC.

    You can do two things here. One is that you can create a completely separate PDB (pluggable database) on the same database service which will provide complete separation between any application and the product schemas or you can create a new schema in the same PDB.

    I would however recommend that you create a new user for any application specific schemas.

    Cheers

  • Chris Maggiulli
    Chris Maggiulli Member Posts: 99
    edited May 17, 2018 11:03PM

    Awesome - yes we decided to implement the PDB approach.  Thank you

This discussion has been closed.