Reply from gregdavis11009 on Apr 10 at 11:47 AM Look into replication. You can have near real time duplication and you can set up your tables with different indexes designed to maximise performance for pulling reports. Reporting tends to work with ranges of data where production is on individual transactions. You don't want to slow down your production system with indexes that are not needed for getting the transactions into the database but you really want indexes and/or partitioning to speed up pulling ranges of data for a report.
| | | ---------------Original Message--------------- From: Helen Jackson Sent: Tuesday, April 03, 2012 9:50 AM Subject: Creating a Database to Use for Reporting We are looking to create a reporting database using the same oracle home as my test database to take some of the traffic from our production database. We have the Sungardhe Banner system and I don't want the job submission or forms piece, just use the current data to pull information, which I plane to refesh every night. Can I create a database that are equal to our production and clone the dbf file to the new database? or please give me the solution of what I should do to make this work. We are using Oracle 11.2. Thanks Helen Jackson (DBA) Chicago State University | | Reply to this email to post your response. __.____._ | _.____.__ |
No comments:
Post a Comment