Installing a 'TEST' instance as a new schema on the same server as the development instance
Hi,
We currently have a 11gR2 'DEV' instance on AIX. We are planning to create a 'TEST' instance by adding it as a new schema (forgive me if my term is wrong). This test is an exact copy of our development instance.
My question is, what is the best/practical/easiest way to do it. I've done this before on a Windows server by create a 'database template' of the dev and applying it as a test (also in the same server). I've read somewhere that this replication (database template) is not advisable on database that already has data.
Please help.
0