RE: WareHouse example information

Mihalis - I haven't used this example, but if you run the following query you could probably find some candidate schemas, assuming the example creates its own schema:

select owner, count(*) from dba_tables group by owner;

If you have a database that doesn't have the example installed, run the query on that and see what isn't listed there.

I personally prefer to figure stuff out myself with techniques like this, but maybe someone who has used the example will reply.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
I said it "looked" clear - Riddick

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Mihalis I. Tsoukalos Sent: Friday, July 02, 2004 10:29 AM
To: oracle-l_at_freelists.org
Subject: Re: WareHouse example information

On Fri, Jul 02, 2004 at 06:58:55AM -0500, DENNIS WILLIAMS wrote:
> Mihalis
> Try user_tables, user_indexes, etc. Good chance to get familiar with
the
> Oracle dictionary.
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
> I said it "looked" clear - Riddick
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Mihalis I. Tsoukalos
> Sent: Friday, July 02, 2004 6:30 AM
> To: Oracle Mailing List
> Subject: WareHouse example information
>
>
> Dear list,
>
> I have installed Oracle 10g (Linux) with the WareHouse example database.
> What I want is to learn more info about this example database (schema
> etc.).
> Where can I find the info?

Yes, but which user is the owner of the example database?

best regards,
Mihalis.

-- 
 18:27:59 up 13 days,  7:31,  2 users,  load average: 0.12, 0.10, 0.03
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------