Home » RDBMS Server » Backup & Recovery » Making a copy of existing Source tables for BI Reporting
Making a copy of existing Source tables for BI Reporting [message #525425] Mon, 03 October 2011 01:10
avrillavinge
Messages: 98
Registered: July 2007
Member
Dear experts,

We have a SAP System in our office which has a oracle Db with its source tables around 50 lets say.

we need to create some reports for the Management using Business intelliegence Tools ..(in our case its SAP BO)

in order to create reports we need a Database on which we can make a reporting layer ie arranging tables joins etc...and then do the reporting ..basically we need a rdbms.

but we cannot do reporting or hit our queries on live DB,hence i want to suggest the DBA to create a copy of the same DB which can store lets say one day old data and can use it in another schema for reporting

Is this possible ? or is there any better way to do this


Pls suggest me the approach as my primary requirement is like a copy fo existing source tables.

Million thanks in advance
Previous Topic: rman backup restoration
Next Topic: rman configuration
Goto Forum:
  


Current Time: Wed Dec 01 20:55:58 CST 2021