Re: HELP!!! HORRIBLE ARCHITECTURE

It strikes me that what you need is not a smart architecture but a competent program manager and a development program and schedule. When I came here we had, for one of the 3 business critical systems I support, 8 dev environments, 2 DBAs reporting to me and no concentration on the other systems at all. We now have 4 dev environments, one consolidated test environment and prod, we also have regular program meetings. We also know about how the other systems work as well. It isn't great - too many clone requests per month, but it is manageable. It's the program management that has made the biggest difference. I do claim credit for insisting on change control and regression testing as per your last email, but really it's the business getting a handle on development that is the key.

Incidentally, one side effect of change control and regression testing by end users is that the teams 'requiring' the 10 different developments simultaneously will likely find they need to resource appropriate testing. This is likely to be a greater strain on them than you and is a great way of discovering the business's real priorities.

cheers

Niall

On 3/2/07, Paula Stankus <paulastankus_at_yahoo.com> wrote:
> yes,
>
> it occurs to me that we will need to setup some serious testing in a staging
> environment that matches production before deploying to production to ensure
> that all of these things come together in the end.
>
> ...sigh...
>
>
> 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.
>
>
> ________________________________
> Don't be flakey. Get Yahoo! Mail for Mobile and
> always stay connected to friends.
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l