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