Re: Test Data, Live Data
Date: 1996/01/31
Message-ID: <4en0n5$d88_at_newsbf02.news.aol.com>#1/1
Thanks, Jacek and Chuck, for your suggestions. Could I ask for a little clarification:
Re: Jacek Dobosz suggestions
(a) um, "schema" ? isn't in the index to my Oracle manuals. HOw do I
create a schema.
(b) "re-create synonyms"... we are using Public Synonyms to point to the
tables now - - if I re-create the synonyms, doesn't that have an effect on
all the other users on the system?
- - - - - -
jdob_at_ping.at (Jacek Dobosz) wrote:
You can put your test data in the same instance but in another schema,
and recreate synonyms to point to the new one.
I use this idea to manage many versions of the application and for
recovery reason when moving new software to production.
...........................................Re: Chuck Hamilton suggestion
Do you mean, as in running two copies of Oracle software on the CPU of my server?
chuckh_at_ix.netcom.com wrote:
Create a 2nd database and run it as a 2nd instance.
- - - - - - start of thread: witthoftm_at_aol.com (WitthoftM) wrote:
I want to set up a test environment with copies of all the same tables as the "live" environment, so I can run test programs without damaging live data. Received on Wed Jan 31 1996 - 00:00:00 CET