I would be remiss not to suggest hot clone/refresh PDBs to an Oracle forum:
SQL> create pluggable database oe_dev from oe@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
On Aug 11, 2017, at 11:30 AM, Gerald Venzl <gerald.venzl@xxxxxxxxxx> 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
People have done it before and are unit testing this way:
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.
Gerald Venzl | Senior Principal Product Manager
Email: gerald.venzl@xxxxxxxxxx <mailto:gerald.venzl@xxxxxxxxxx> | Phone:
Oracle ST & Database Development
400 Oracle Parkway | Redwood Shores | 94065 | USA
On Aug 11, 2017, at 11:06, Chris Taylor <christopherdtaylor1994@xxxxxxxxx
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
On Fri, Aug 11, 2017 at 12:59 PM, Tim Gorman <tim.evdbt@xxxxxxxxx
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
I'm curious what products are available that could facilitate something
I was thinking something like this:
Unit Test (UT Master) - code replicated from production nightly (never used
How could I facilitate users creating a copy on demand of UTMaster using
I'm basically looking to see what options are to accomplish something like
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.