Prod RAC to Test RAC to DEV Single Instance Refresh of 2 Schemas
.
Environments
Production - Oracle Database 11.1.0.6 EE (3 node RAC)
Test - Oracle Database 11.1.0.6 EE (3 node RAC)
Dev - Oracle Database 11.1.0.6 EE (Single Instance)*
* a second unrelated database exists on Dev server in its own ORACLE_HOME
.
All database data and fra are stored on Oracle ASM. There is one Siebel schema stored in two different Tablespaces (siebel data and siebel indexes respectively). Another schema is stored in two different tablespaces (users and indexes respectively). The Siebel schema serves to house a Siebel CRM Data Model. The Siebel Data Model has many columns phyically implemented as LONG datatypes. The LONG datatypes are typically not at the end of the table.