RE: HELP!!! HORRIBLE ARCHITECTURE

From: Stephens, Chris <chris_stephens_at_admworld.com>
Date: Fri, 2 Mar 2007 14:11:13 -0600
Message-ID: <7070047601C21A4CB387D50AD3661F6E06471E7C@050EXCHANGE.research.na.admworld.com>

why not consolidate the schemas?

....spend some time with the developers to provide a single schema interface to everything.

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Paula Stankus Sent: Friday, March 02, 2007 1:43 PM
To: Paula Stankus; oracle-l_at_freelists.org Cc: Oracle Discussion List
Subject: Re: HELP!!! HORRIBLE ARCHITECTURE

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

<http://us.rd.yahoo.com/evt=49938/*http://tools.search.yahoo.com/toolbar
/features/mail/> alerts you the instant new Mail arrives. Check it out.
<http://us.rd.yahoo.com/evt=49937/*http://tools.search.yahoo.com/toolbar
/features/mail/>

Don't be flakey. Get Yahoo! Mail for Mobile
<http://us.rd.yahoo.com/evt=43909/*http://mobile.yahoo.com/mail> and
always stay connected
<http://us.rd.yahoo.com/evt=43909/*http://mobile.yahoo.com/mail> to
friends.

CONFIDENTIALITY NOTICE:
This message is intended for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient or the employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by email reply.

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Mar 02 2007 - 14:11:13 CST