471,108 Members | 1,274 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,108 software developers and data experts.

how to view sample schema

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

Jul 19 '05 #1
2 8898
In article <Gy*****************@nwrddc02.gnilink.net>,
re******@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
Jul 19 '05 #2
aK wrote:
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
da******@x.washington.edu
(replace 'x' with a 'u' to reply)

Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Josh Martin | last post: by
6 posts views Thread by Eugene | last post: by
4 posts views Thread by Ganesh Muthuvelu | last post: by
2 posts views Thread by aK | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.