Re: Creating an Oracle Reporting Server

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Wed, 18 Jun 2003 20:08:10 GMT
Message-ID: <3ef0c67f.1142865263@nyc.news.speakeasy.net>

If you don't need _all_ the data, snapshots are a good way, and can update incrementally.
You can then process the data as you wish on the warehouse (summaries, extra indices, etc).

On 17 Jun 2003 14:30:42 -0700, jchenning_at_yahoo.com (Joseph C. Henning) wrote:

>I have a question on the number of ways you can replicate a production
>database to a reporting server (data warehouse). Can this be done by
>hot backups? Can this be done on a transaction basis? Just looking
>for different ideas on how to do this task. Any help would be great.
>
>Regards,
>Joe

.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email Received on Wed Jun 18 2003 - 15:08:10 CDT