Is it possible to see how much space 1000 000 rows take?
Hi,
I try to view the space usage of 1000 000 rows.
I try this:
select a.segment_name, sum(bytes)/1024/1024 MB, b.rowid from dba_segments a, DW.mytable b where a.segment_name='DW.mytable'
and b.rowid<1000000;
I get an ORA-00932 back. "Expected ROWID but got number".
How do I do this?
Regards
U
I try to view the space usage of 1000 000 rows.
I try this:
select a.segment_name, sum(bytes)/1024/1024 MB, b.rowid from dba_segments a, DW.mytable b where a.segment_name='DW.mytable'
and b.rowid<1000000;
I get an ORA-00932 back. "Expected ROWID but got number".
How do I do this?
Regards
U
0