Re: Developers wanting individual Unit Test (no data) databases - suggestions?

Hi Chris,

well you can, you would just need to license for multienancy, where as single tenancy is a no cost license.

thanks,
jpm

> On Aug 11, 2017, at 12:50 PM, Chris Taylor <christopherdtaylor1994_at_gmail.com> wrote:
> 
> That's an interesting idea as well but we'd have to have to multiple instances - each with 1 pdb for each developer.  It would be nice if we have multi-tenant and then we could spin up multiple pdbs as needed - all running off 1 instance.
> 
> Chris
> 
> On Fri, Aug 11, 2017 at 1:53 PM, John Mchugh <john.mchugh_at_oracle.com <mailto:john.mchugh_at_oracle.com>> wrote:
> I would be remiss not to suggest hot clone/refresh PDBs to an Oracle forum:
> 
> SQL> create pluggable database oe_dev from oe_at_prod_system no data;
> 
> If cloning from an EE prod system to an SE dev env. there is no Multitenant licensing costs for single tenant 
> in the dev env. and the operation is storage agnostic.
> 
> An example of how some customers leverage this via REST calls to provision the PDB:
> 
> 
> 
> thanks,
> jpm
> 
>> On Aug 11, 2017, at 11:30 AM, Gerald Venzl <gerald.venzl_at_oracle.com <mailto:gerald.venzl_at_oracle.com>> wrote:
>> 
>> If you don’t need the data and just want to run a local database on a laptop that they can develop and run tests against then really Docker is the way to go. :)
>> People have done it before and are unit testing this way: https://github.com/oracle/docker-images/tree/master/OracleDatabase/samples/prebuiltdb <https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_oracle_docker-2Dimages_tree_master_OracleDatabase_samples_prebuiltdb&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PQcxBKCX5YTpkKY057SbK10&r=hiDGYU-Eo9j8HVX_-povc-fRVvZ6ACBK_fWiVQK2zrc&m=4v5W7cUWtYPd987gBFq8r7cWk-zj9kI63w-WIO6dA9U&s=90ERNzUtLHkxHTVSpQtyxZt4UNKowWK2xVLnY2FzBc8&e=>
>> It allows you to spin up a DB in a matter of seconds and if they have done something wrong or want to start from scratch they can just throw away the container and spin up a new one.
>> 
>> Happy to help exploring this further, you got my email.
>> 
>> Thx,
>> ---------------
>> 
>> Gerald Venzl | Senior Principal Product Manager
>> Email: gerald.venzl_at_oracle.com <mailto:gerald.venzl_at_oracle.com> | Phone: +1.650.633.0085 <tel:+16506330085>
>> Oracle ST & Database Development 
>> 400 Oracle Parkway | Redwood Shores | 94065 | USA
>> 

>>>> We've got a relatively large development group who want to have many Unit Test databases (without data) that they can spin up on demand and destroy when done.
>>>> 
>>>> I'm curious what products are available that could facilitate something like this?
>>>> 
>>>> I was thinking something like this:
>>>> 
>>>> Unit Test (UT Master) - code replicated from production nightly (never used for testing)
>>>> 
>>>> How could I facilitate users creating a copy on demand of UTMaster using something like:
>>>> 
>>>> VMWare or
>>>> Delphix or
>>>> Docker or
>>>> something
>>>> 
>>>> I'm basically looking to see what options are to accomplish something like this.
>>>> 
>>>> I was thinking if we stood up UT Master on a VM, we could snap the VM into another copy for a specific developer on demand.
>>>> 
>>>> Chris
>>>> 
>>>> 
>>>> 
>>>> 
>>>> 

>> 
> 
> 

--
http://www.freelists.org/webpage/oracle-l