I am just learning Oracle 9i and SQL Plus. After going through
setting up everything and examining the starter database I have found
that SQL Plus will not allow me to everything in the database.

Example: If I log in using Sys/password I can see system related
tables but I cant query on the example schemas that were installed.

If I log in as Scott/tiger I can see that schema and tables.

Is there an account that will allow me to see everyone's schema setup
and also query on it?

I would like to log on once in a non administrator account and be
able to query on any table in any schema including some of the
system views.

I am working on my Applications Developer cert and really need to know
the workings of tables and schema for development purposes.

Any help would be appreciated. Thanks JW