Re: how to view sample schema
From: tojo <Tojo_at_hotmail.com>
Date: Wed, 3 Sep 2003 08:52:37 +0200
Message-ID: <MPG.19bfae1d7eb5c8109896a6_at_news.t-online.de>
Date: Wed, 3 Sep 2003 08:52:37 +0200
Message-ID: <MPG.19bfae1d7eb5c8109896a6_at_news.t-online.de>
In article <Gye5b.8560$9T1.7008_at_nwrddc02.gnilink.net>,
res1e24o_at_verizon.net says...
> what's the command to view if the sample schema has been installed with 9i
> on my RH7.3?
>
Log on as SYSTEM, then
select owner, count(*) num_schema_tables
from dba_tables
group by owner
Owners for sample schemas will be OE, PM, HR, stuff like that.
- Tom