Re: environment replication

steve,

I just looked at the oracle docs on exp/imp which says it should save and restore all objects owned by the user. ( by the way I am currently trying to figure out how to restore into a user tablespace without first having to drop all the objects for a refresh ).

We were thinking of using one instance as a resource saving device ( memory essentially ) and also we are a Sybase shop and that is the way you do it in Sybase. Oracle folks seem to have the same question you have about why not just create seperate databases...

dave

In article <889002092.7532.0.nnrp-02.c2de712e_at_news.demon.co.uk>,   "Steve Phelan" <stevep_at_XXnospamXX.toneline.demon.co.uk> wrote:
>
>
> lopezd_at_sni13.viacom.com wrote in message
> <6dhmso$p71$1_at_nnrp1.dejanews.com>...
> >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?
>
> Er, not quite sure why everything else is OK, but the packages are causing
> you a problem. What problem in particular?
>
> Yes, you can create separate environments in the same instance, but if one
> is for, say, test, one live, one user acceptance test, and so on (or any
> permutation of) I'd recommend a separate database. In other words, WHY do
> you want the replicated environments?
>
> Steve Phelan.
>
>

-----== 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