Database Utilities (MOSC)

MOSC Banner

Prod RAC to Test RAC to DEV Single Instance Refresh of 2 Schemas

edited May 24, 2010 11:06AM in Database Utilities (MOSC) 4 commentsAnswered
I would like to find the most efficient and effective way to recreate, overwrite or replicate two schemas from my Production Database to my Test and Dev databases.

.

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. 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center