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

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

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'

hi

for the above question the answer is

select * from tab;

here * represents list of tables.

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';

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

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

1Block 8192 bytes

1 extent 1024 blocks

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;