i want to see table names of other user

[binoyshil]

--------------------------------------------------------------------------------

i want to see the name & structure of all the tables of another user
provided the grant is given.

for example: i have got two user :NHPC4 and NHPCTEMP.
now when i logon to nhpc4 user,i want to see table name & structure of all the tables of nhpctemp.


should i write this:

select * from .tab where tname like 'ABC%'
which is not working.

[davey23uk]

desc nhpctemp.tab_name

[binoyshil]

this will show me structure of one table only and that too will be table which i know.
but i want to see all the tables created by other user(nhpctemp),while logon to nhpc4
since i don't know the name of the tables of nhpctemp.

[davey23uk]

select * from all_tables where owner = 'NHPCTEMP';