Re: duplicating ORACLE GL database for quick report...

GL has many tables and is very complex. You maybe able to mirror your database on another system
and run reports against the mirrored copy. or
We do make periodic copies of the Oracle Financials database at the file level for our test SID. The copy process takes about 4 hours. Once the system is copied we or you could run any reports.

just a few thoughts. Good luck.
peewee_at_club-internet.fr wrote in article <874306244.20616_at_dejanews.com>...
>
> We're implementing Oracle GL v10.7 on an UNIX server / a 50 client
> forecast.
>
> Many reports will be developped under FSG and we fear an
> overload of the main database.
>
> Our consultant suggested us the possibility of
> duplicating easily the GL database and launch
> - in real time - FSG queries on the copy.
>
> Is it a valuable method ? Is it a reliable choice ?
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
>
  Received on Fri Sep 19 1997 - 00:00:00 CDT