Skip to Main Content

Oracle Database Discussions

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!

Oracle 12c - Using PDBs as a way to create isolated database development environments

GleannFiaAug 2 2018 — edited Aug 7 2018

Hi,

I'm interested to find out if anybody in the community has installed Oracle 12c for the purposes of allowing database developers

to develop database code that is insulated from other developers. i.e. In a Dev environment only.

In other words, creating a PDB (pluggable database) for each developer.

I know you could create separate schemas for each developer but that's not a practical option in my case.

There are already lots of development schemas used for specific applications and some that are shared between applications.

Are PDBs a viable solution?

Is it an expensive option? i.e. the multi-tenant license would have to be purchased.

Are there any DBA problems using this new architecture?

Are there better and cheaper alternatives?

Remember this is only for dev. Non-CDB setup will be used in Test and Production.

It's a possible solution to make development easier in the database.

Instead of sharing one dev database, each developer gets their own copy in a dedicated PDB database.

Thanks in advance for any advice you may have.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 4 2018
Added on Aug 2 2018
12 comments
753 views