Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> 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