Results 1 to 2 of 2

Thread: Table size

  1. #1
    Join Date
    May 2004
    Posts
    95

    Unanswered: Table size

    Hi everybody,

    I need to see the space used by a table. So far no problem, with:
    Code:
    SELECT segment_name table_name, owner, bytes
     FROM dba_segments
     WHERE segment_type = 'TABLE' AND table = 'WORKERS'
    I'm getting the total space.

    Now the twist. How can I see that space, but with a where condition.
    For example, I need to know how much space is used on the table 'WORKERS' for the company_id Y.

    As an additional info, the table has a set of all kind of collumn types, including BLOB's and CLOB's.

    Thanks in advance.

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Using grouping clause you can sum for a particular table but you can't examine the data within the segments using dba_segments.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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