Re: Discoverer

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)