DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Database Cluster table

Hybrid View

  1. #1
    Join Date
    May 2002
    Posts
    163

    Database Cluster table

    Hi All,
    When I query my User_Tables, for 2 tables I can not see any tablespace name. Later I came to know that they are cluster tables.

    To get all Database Informations for those 2 tables, which are the data dictionary tables I have to look into? Can you please guide me with all required dictionary table names please!


    Thanks
    Nwcomer
    Student

  2. #2
    Join Date
    May 2002
    Posts
    163
    Any update please?
    Nwcomer
    Student

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Check the following views:
    USER_CLUSTERS, ALL_CLUSTERS, and DBA_CLUSTERS
    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