Re: Test Data, Live Data

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.
>In SyBase I would simply create another Database, and then by saying
>either
>Use MyFirstDatabase
>or
>Use MySecondDatabase
>all subsequent table references would point to the appropriate spot.
>
>In Oracle it appears I have to have sets of tables created by different
>users, and then change my >>UserID<< to look at a different set of tables
>.... ? ? Surely I am simply overlooking something. ?
>
>

When you want to switch between schemas use: SQL> connect <username>

When you want to use another database use SQL> connect <username>_at_<database>

I hope this helps.

-- 
===============================================================
Richard Bennett		E-Mail: richhb_at_sequent.com
				73501.1703_at_compuserve.com
Computer People Inc.	On contract to Sequent Computer Systems