-
i want to see table names of other user
--------------------------------------------------------------------------------
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.
-
-
i want to see all the tables
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.
-
select * from all_tables where owner = 'NHPCTEMP';
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|