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@xxxxxxxxxxxxx I said it "looked" clear - Riddick -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Mihalis I. Tsoukalos Sent: Friday, July 02, 2004 10:29 AM To: oracle-l@xxxxxxxxxxxxx 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@xxxxxxxxxxxxx > I said it "looked" clear - Riddick > > > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx]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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------