i want to see table names of other user
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: i want to see table names of other user

  1. #1
    Join Date
    Feb 2006
    Posts
    86

    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.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    desc nhpctemp.tab_name

  3. #3
    Join Date
    Feb 2006
    Posts
    86

    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.

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    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
  •  



Click Here to Expand Forum to Full Width