var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Table size
I need to see the space used by a table. So far no problem, with:
I'm getting the total space.
SELECT segment_name table_name, owner, bytes
WHERE segment_type = 'TABLE' AND table = 'WORKERS'
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.
Using grouping clause you can sum for a particular table but you can't examine the data within the segments using dba_segments.
You do not need a parachute to skydive. You only need a parachute to skydive twice.