Re: Newbie question .....

From: bgt0990 <btighe_at_neometrics.com>
Date: Tue, 4 Jun 2002 07:01:23 -0400
Message-ID: <3cfc9c5c$1_2@corp-goliath.newsgroups.com>

Start reading the documentation

"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

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Tue Jun 04 2002 - 06:01:23 CDT