Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: environment replication

Re: environment replication

From: Andrew Protasov <protasov_at_percombank.kiev.ua>
Date: 1998/03/04
Message-ID: <6djqtb$eq9$1@news.lucky.net>#1/1

Hi,

What is a problem? Simply create development schema for each user. Each of them will have own copy of tables, packages and so on. This can be done in single instance.

                       Andrew Protasov

lopezd_at_sni13.viacom.com wrote in message <6dhmso$p71$1_at_nnrp1.dejanews.com>...
>
>
>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 Wed Mar 04 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US