Reply from SteveFLHSMV on Apr 10 at 12:15 PM In addition to eliminating some indexes and adding others, replication will may allow you to eliminate some constraints if they're solely for enforcement of uniqueness, validity, etc. Also, partitioning is not the same as indexing, but may be useful for tables in the reporting DB even when partitioning the source table is less compelling.
| | | ---------------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