Re: User views: DBA_USER, V and $ tables, data definition language.

from sql*plus (a command line interpeter for SQL statements): select view_name from user_views; -- all views you own select owner, view_name from all_views; -- all_views you own and views owned by others that granted you select on them select owner, view_name from dba_views; -- all views in data dictionary; must be sys or system

similar constructs for tables, indexes, constraints, etc. e.g., select owner, table_name from all_tables;

Platinum has a great app which shows all the data dictionary views for Oracle8. I got it from their web site.
--
- Dan Clamage
http://www.telerama.com/~dclamage
If you haven't crashed the Server,
you haven't been trying hard enough.
christoph erdt wrote in message <366b774d.5103628_at_news.halcyon.com>...
>I just installed Oracle 8 enterprise 30 day demo CD from Oracle for
>the purpose of learning ahead of upcoming DBA class and I am lost
>since i cannot find the command line to be able to display the views
>or tables nor can I find any icon that would allow me to practice
>commands like : create, autoextend, maxlogfiles , maxlogmembers etc.
>
>can someone tell me what to do to find the commandline...thanks
Received on Mon Dec 07 1998 - 12:42:07 CST