how to view sample schema

#1

what's the command to view if the sample schema has been installed with 9i
on my RH7.3?

#2

In article <Gye5b.8560$9T1.7008 (AT) nwrddc02 (DOT) gnilink.net>,
res1e24o (AT) verizon (DOT) net says...

Quote:

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

#3

aK wrote:

Quote:

what's the command to view if the sample schema has been installed with 9i
on my RH7.3?

There are multiple sample schemas ... some or none of which might have

been installed.

Log on as system and:

SELECT username
FROM all_users;

And please don't cross-post to every Oracle group you can spell.

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

how to view sample schema

comp.database.oracle comp.database.oracle

how to view sample schema - 09-02-2003 , 11:59 PM

Re: how to view sample schema - 09-03-2003 , 01:52 AM

Re: how to view sample schema - 09-03-2003 , 10:05 AM