environment replication

From: <lopezd_at_sni13.viacom.com>
Date: 1998/03/03
Message-ID: <6dhmso$p71$1@nnrp1.dejanews.com>#1/1

Greetings,

I have a development environment that I want to replicate into another environment and I am looking for techniques on how to accomplish this.

Oracle gives me the export/import utility which is very nice for moving tables based on owner around.

I want to create an environment A in instance RED and environment B in the same instance RED. I know I can create two users USER_A and USER_B and give them permissions to create tables and such in tablespace A and tablespace B.

I can create appropriate users and roles which can be granted permissions on either tables in A or B as appropriate. My problem is in utilization of packages and such. Am I using the wrong paradigm in trying to create this environment? Or can I get away with trying to seperate the environments in the same instance?

Dave

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Mar 03 1998 - 00:00:00 CST