how to see multiple table structures in a single query ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: how to see multiple table structures in a single query ?

  1. #1
    Join Date
    Oct 2002
    Posts
    284

    how to see multiple table structures in a single query ?

    hello all..

    i am on Oracle 817. i have a schema named " HEAT". i ahve some 20 odd tables under this schema. now my developers want the structure of all the tables in that schema.

    I know we can run DESC < Table name> to see structure of each table. But is there a query where i can run that will get me the structure of all the tables in a particular schema ?

    Thans a lot
    Ron

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Query the dba_tables, dba_tab_columns views for owner = 'WHATEVER'
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Select * From dba_tab_columns Where owner = 'HEAT';

  4. #4
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    User_Tab_Columns... BTW, RTM
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  5. #5
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Code:
           SET ECHO ON
           SET HEADING OFF
           SET FEDDBACK OFF
           SET PAGESIZE 100
           SPOOL desc_user_tables.sql
           SELECT 'DESC '||table_name FROM dba_tables
           WHERE owner = 'HEAT'
           SPOOL OFF;
           SET HEADING ON
           SET FEDDBACK ON
           @desc_user_tables.sql
    Hope this would help you.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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