Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Creating an Oracle Reporting Server

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US