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

Thread: what extent am i on?

  1. #1
    Join Date
    Jan 2001
    Posts
    515
    How do I determine what extent my tablespace is currently on?

  2. #2
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    If you have DBA Studio, look at the properties of the table.

    Otherwise you can try looking at DBA_SEGMENTS or DBA_TABLES.

    Good luck.
    David Knight
    OCP DBA 8i, 9i, 10g

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well you probably really mean "What blocks is my tablespace using" Extents forms segments, segments tablespace, in other words you can have duplicate extent id in a tablespace whereas block id is unique

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