Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Location
    Pune, India
    Posts
    15

    Unanswered: finding space occupied by a table and its related indexes

    hi all...

    I need to find the space occupied by a certain table on abc tablespace (which also contains some other tables ) and the space occupied by its related index/es....Which data dictionary would give me that statistics. I tried to query user_tablespaces and dba_free_space but it does not give the needed breakup. It onyl gives the overall space free on a table space.

    Pls help at the earliest.
    Thanks in advance.

    regards
    abhivyakti

  2. #2
    Join Date
    May 2004
    Posts
    8
    Hello Abhivyakti,

    where you're probably looking for is:

    select bytes/1024 KB
    from dba_segments
    where segment_name = 'XXX'
    and owner = 'YYY';

    Hope this helps,
    Noel.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •