why not consolidate the schemas? ....spend some time with the developers to provide a single schema interface to everything. ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Paula Stankus Sent: Friday, March 02, 2007 1:43 PM To: Paula Stankus; oracle-l@xxxxxxxxxxxxx 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@xxxxxxxxx> 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.