Re: Newbie question .....

I could write a book to answer the questions you ask (in fact, people have) but here are a few pointers to get you started.

There are two sets of views that you can query for the metainformation. The ALL_??? views contain information about all database objects but you must be logged in as a dba to view them. The USER_??? views hold data about objects owned or accessible to the current user. In many cases there is both a ALL_ and USER_ view such as:

ALL_TABLES displays all tables, USER_TABLES displays tables owned by the current user.
ALL_INDEXES displays all indexes, USER_INDEXES displays indexes owned by the current user.
There is also ALL_/USER_CONSTRAINTS showing constraint information and ALL_/USER_USERS showing defined users, although USER_USERS is not much use if you ask me.

The above views a based on the system V$??? views. You should read the documentation for details on these, but the V$SESSION view will show you who is current logged in, where there are logged in from, when they logged in, etc.

HTH "Mahesh Hardikar" <hardikarm_at_yahoo.com> wrote in message news:4a1c57c2.0206040130.1d896974_at_posting.google.com...
> Hello ,
>
> I am a Newbie in Oracle . How do I find out table related information
> like :
>
> Current Size of Table & its related Index
> Dependencies of / upon Table
> Index columns of table
> Permissions on the table
>
> Also I want to find out currently connected users to Oracle Instance &
> the last command run by those users.
>
> I know I can use Enterprise Manager but I want to know commands from
> SQL Plus.
>
> I have created a user with default tablespace as USERS . User has
> CONNECT & DBA Previlages. I then created a table using newly created
> user. I checked with desc tab_name but it gives me information only
> about column names & datatypes.
>
> I tried doing selects on some views of SYSTEM user . But those doesnot
> seem to have any information about objects on different Tablespace.
> Correct me if I am wrong.
>
> Thanks
> Mahesh
Received on Tue Jun 04 2002 - 06:06:56 CDT