Database DataWarehousing (MOSC)

MOSC Banner

How refresh Datawharehouse (DSS) TEST with Copy from PROD

edited Apr 7, 2010 2:15AM in Database DataWarehousing (MOSC) 3 commentsAnswered
  Dear Dba's

I'm facing a wired issue.

We've a Datawharehouse for (DSS - Decision Suport System)  and recently I've been ask to refresh Test Database with a copy from Prod.

I'm not a DSS specialist, most of my 12 years experience are in OLTP Db's.

To resume : oracle 9R2 on Linux RH5.

There are 6 user Schemas (created for Application) and the standard Oracle Schemas as copy below

  

Schemas for Aplplication - Truncated tables and Imported Data

REPDWH     
REPODS     
REPSAS     
SIEBELDWH  
SIEBODS    
SIEBSAS     
IT   

 

Schemas I ldidn't Touch But I think they are need for DSS


DBSNMP     
DWHSYS      
MDSYS      
ODM        
ODM_MTR    

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center