On 12/12/2017 06:03 PM, Pete Sharman wrote:
As always, Oracle has about 15 zillion ways to do the same thing. There’s not enough information here to know which is the best option for what you want to do, but you might want to look at the snapshot database command in 12c, Snap Clone from EM, or Delphix in addition to Fairlie’s comment to do what you want. Which one is best depends on your requirements.