I'm bit late with the reply but you might find my presentation about
effective test systems management useful. It's pretty much your case
one to one!
Get the file there -
http://www.pythian.com/blogs/309/ukoug-2006-presentations-available
(it's the last one in the list).
On 3/2/07, Paula Stankus <paulastankus_at_yahoo.com> wrote:
> Here it is and if someone has a good solution let me know.
>
> I have inherited this database with multiple, multiple schemas.
>
> The schemas have views and the views access more schemas.
>
> The database is very large.
>
> I have about 10 development groups needing (per their request) 10 separate
> instances to develop on because they are in different phases of development.
>
> Refreshing the databases is a nightmare. Just when you thought you were
> done you need yet another underlying schema.
>
> I don't have enough space for 10 clones of prod (wish I did)
>
> Any suggestions???
>
> ________________________________
> Never miss an email again!
> Yahoo! Toolbar alerts you the instant new Mail arrives. Check it out.
>
>
--
Best regards,
Alex Gorbachev
http://www.oracloid.com
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Mar 12 2007 - 21:53:29 CDT
