Re: Replicating E-Business Suite for Reporting

Allan,

EBS has thousands of tables that are potentially updated frequently (and which ones are and which ones aren't is not that well documented). In this scenario, an LSB/Streams scenario may be difficult to implement given the number of objects. I would recommend a PSB where you switch between reporting and log application.

John

On 8/3/07, Allan Nelson <anelson77388_at_gmail.com> wrote:
>
> Hello All,
>
> I am working on a project to create a reporting environment from an Oracle
> E-Business suite database that will be at 10.1.0.5 by the time the
> reporting project takes off. The source database is on HP-UX 11.11 and is
> about 750GB in size. In the generic sense of requirements this is what I
> would like to do:
>
>
> 1. The target will be a copy of the source without applying data
> warehouse techniques. I will be able to add a few indexes or views.
> 2. I would like to use RAC on Redhat Linux as the target platform
> both for availability reasons and lease termination reasons .
> 3. If at all possible I would like to use 10gR2 for the target
> database
> 4. I cannot upgrade the source to 10gR2.
>
> I was thinking about using a logical standby and still am, but I would
> have to do that all on HP. According to the DataGuard docs the platforms
> have to be the same with regard to OS flavor but not with respect to
> hardware.
>
> I'm not adverse to Streams or a third party solution and I would like some
> pointers on where to start researching. I'm reading up on Streams now.
>
> I know this is vague but it is what I have at present.
>
> Thanks in Advance
> Allan Nelson
>

-- 
John Kanagaraj <><
DB Soft Inc
http://jkanagaraj.wordpress.com (Sorry - not an Oracle blog!)
** The opinions and facts contained in this message are entirely mine and do
not reflect those of my employer or customers **

--
http://www.freelists.org/webpage/oracle-l