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

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> 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>
> 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 | Phone: +1.650.633.0085 <+16506330085>
> Oracle ST & Database Development
> 400 Oracle Parkway | Redwood Shores | 94065 | USA
>
> On Aug 11, 2017, at 11:06, Chris Taylor <christopherdtaylor1994_at_gmail.com>
> wrote:
>
> We really don't need the data. Theoretically we'd have an empty Unit Test
> master db to use.
>
> Already sent a reply back to Kellyn so those same questions apply to you
> but with one additional:
>
> These new copies, could any of these be run on developer workstations
> instead of a server? Does Delphix have a way to facilitate bringing a copy
> down to a workstation (since we're talking about 70-100 GB only without the
> actual data).
>
> Chris
>
>
> On Fri, Aug 11, 2017 at 12:59 PM, Tim Gorman <tim.evdbt_at_gmail.com> wrote:
>
>> This is how most (if not all) of 300+ customers use Delphix for
>> virtualizing Oracle, MSSQL, DB2, Sybase, and application tiers.
>>
>> Make full-size, read-write clones quickly and cheaply, use them, get rid
>> of them, or archive them for easy restore.
>>
>> If you want a full environment to play with and show you around, I can
>> make one for you in a couple minutes.
>>
>> Full disclosure: I work for Delphix. Not sales, just enthusiasm.
>>
>>
>>
>> On 8/11/17 11:25, Chris Taylor wrote:
>>
>> 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