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: Discoverer

Re: Discoverer

From: Daniel Morgan <damorgan_at_exxesolutions.com>
Date: Wed, 09 Jul 2003 09:05:32 -0700
Message-ID: <3F0C3D4C.8C288B7D@exxesolutions.com>


Andy wrote:

> A little confused about Discoverer concepts.
>
> I have a database with multiple schemas. There is a need for reporting
> (ad-hoc as well) against data in each of the schemas.
>
> Given this background...
>
> 1) Do you create a single EUL for the whole database or is the EUL per
> schema.
> 2) What are best practices when designing a Discoverer Environment.
>
> ENVIRONMENT:
>
> ORACLE 9.2 Enterprise Database
> ORACLE Real Applicaiton Cluster
> LINUX Red Hat Advanced Server.
> Oracle 9i Application Server Enterprise.
>
> Thanks

There is no single correct answer. You create an EUL that best fits the needs of those doing the reports. If a single report crosses schemas ... cross schemas. If not ... don't.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Wed Jul 09 2003 - 11:05:32 CDT

Original text of this message

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