Rakesh Gautam

• Jul 5th, 2005

 

query dba_tables where owner=' ' 
 
group by owner 
 
login as owner 
select tname from tab; 
 

zakariya

• Sep 22nd, 2005

 

hi,

user_tables will list all the tables owned by the currently connected user. Or query the dba_tables for the required user.

Rgds

Zakariya

Chiranjeevi Manne

• Nov 9th, 2005

 

Even it is possible by querying the dbd_objects view and using the where conditions based on owner=<user_name> and object_type=TABLE

ASIM JAMAL

• Nov 14th, 2005

 

this could be found  through

1. select table_name from sys.dba_tables where owner='specified user'

2. select * from cat;

3.select * from sys.dba_objects where owner ='specified owner'

poornima

• Dec 14th, 2005

 

hi,

                   for the above question the answer is

                      select * from tab;

                         here * represents list of tables.

Nagarjuna Reddy

• Jan 9th, 2006

 

Hi the solution for the above question is

either

SELECT COUNT(TABLE_NAME) FROM DBA_TABLES WHERE OWNER='DBO';

If u have sys privilleges

or

SELECT COUNT(TABLE_NAME) FROM ALL_TABLES WHERE OWNER='DBO';

Ajay

• Feb 17th, 2006

 

select t_name from tab where user = ' ' ;

Star Nirav

• Mar 24th, 2006

 

Well but if i want to find out the size of the tables/indexes of particular users, then which query i should fire... ?

Pls. let me know at the earliest.

Thanks in advance.

Star Nirav

sumandb

 Profile Answers by sumandb 

• May 27th, 2006

 

take it from DBA_TABLES or USER_TABLES...where u will select the Block.

1Block= 8192 bytes

1 extent = 1024 blocks

Vimal Kumar

• Jun 27th, 2006

 

If you want to list out the tables of a different user name, then DBA_TABLES would be the idle one.

Select table_name from DBA_TABLES where OWNER = '---';

Note the owner name should be in capital letters only.

For listing out in your own account

select * from tab;

select t_name from tab;

options

select table_name from user_tables;

cmanne

 Profile Answers by cmanne 

• Jul 29th, 2006

 

Method 1: if you are a DBA query DBA_TABLES or DBA_OBJECTS

Method 2: If you are an ordinary user query USER_TABLES

jl

• Aug 25th, 2006

 

in sql server this should be achieved like this:

1. find that user's uid from sysusers table by select uid from sysusers where name = 'username'

2. find the table names from sysobjects table by select name from sysobject where uid = 'selecteduid'

of course these two steps can be done in one step

subha gunasekaran

 Profile Answers by subha gunasekaran 

• Jun 5th, 2008

 

select sum(bytes)/1024 from dba_segments where segment_name='TABLE_NAME' and owner=' '

As segment_name represents table_name,index_name..provide the table_name and index_name in the above query

bapiora

 Profile Answers by bapiora 

• Jun 29th, 2009

 

As a dba if you want such info. from your database side.

You issue following command from server end.

   select owner,table_name,tablespace_name from dba_tables or if you need some specific user info. issue   select owner, table_name ,tablespace_name from dba_tables where owner='< username>'