Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Replicating E-Business Suite for Reporting

Re: Replicating E-Business Suite for Reporting

From: John Kanagaraj <>
Date: Sat, 4 Aug 2007 22:13:21 -0700
Message-ID: <>


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.


On 8/3/07, Allan Nelson <> 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 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 (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 **

Received on Sun Aug 05 2007 - 00:13:21 CDT

Original text of this message