Re: how to view sample schema

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