RE: WareHouse example information

  • From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
  • To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 2 Jul 2004 10:31:53 -0500

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

Other related posts: