Re: Creating an Oracle Reporting Server

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Wed, 18 Jun 2003 08:23:09 +0200
Message-ID: <9910fv81op48cnltb93c3crvdeg2ut90m2@4ax.com>

On Wed, 18 Jun 2003 00:11:51 +0200, "Anton Buijs" <remove_aammbuijs_at_xs4all.nl> wrote:

>
>Joseph C. Henning <jchenning_at_yahoo.com> schreef in berichtnieuws
>685bef7f.0306171330.77a2a699_at_posting.google.com...
>| 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
>
>Make a standby database that is constantly fed by the archives of the
>orgininal database.
>That standby database can be opened for read only.
>Always forget in which version a feature becomes available but I think it is
>9.0 in this case.
>

This feature came available as standby database in 8i, and is renamed to dataguard in 9i

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Jun 18 2003 - 01:23:09 CDT