DEV and QA within single oracle instance
We need to have our DEV and QA in a single oracle instance. Scripts that refer to tables names in DEV will be copied over to QA for QA testing when unit testing in DEV has been completed. In DEV, we extract data from 5 source systems, one for each US state, which use the same application so the source table names are identical, and therefore in our staging area we have a schema per state such as TX, GA, MD and we extract data into staging tables that are identical to the source tables. Since we do cross state aggregation our scripts have to refer to TX.employee and GA.employee in the same sql statement.
What is the best design for this using SCHEMAS, VIRTUAL PRIVATE DATABASES, VIEWS , SYNONYMS etc?
Thanks in anticipation
Edited by: user4900730 on Mar 22, 2011 2:53 PM