ORA-01722
Hi,
when I run the following query,
select owner, table_name, tablespace_name,estime "Estimé", reel "Réel", reel-estime "Ecart", round((reel-estime)*100/reel,2) "Pourcentage"
from (
select t.owner, t.table_name,t.tablespace_name,round((t.num_rows*t.avg_row_len)/1024/1024,0) estime,
round((t.blocks+t.empty_blocks)*to_number(v.value,'9999')/1024/1024,0) reel
from dba_tables t, v$parameter v
where v.name='db_block_size'
and nvl(t.num_rows,0) >0
and t.blocks is not null
and t.cluster_name is null
and t.tablespace_name not in ('SYSTEM','SYSAUX')
and round((t.num_rows*t.avg_row_len)/1024/1024,0) !=0
when I run the following query,
select owner, table_name, tablespace_name,estime "Estimé", reel "Réel", reel-estime "Ecart", round((reel-estime)*100/reel,2) "Pourcentage"
from (
select t.owner, t.table_name,t.tablespace_name,round((t.num_rows*t.avg_row_len)/1024/1024,0) estime,
round((t.blocks+t.empty_blocks)*to_number(v.value,'9999')/1024/1024,0) reel
from dba_tables t, v$parameter v
where v.name='db_block_size'
and nvl(t.num_rows,0) >0
and t.blocks is not null
and t.cluster_name is null
and t.tablespace_name not in ('SYSTEM','SYSAUX')
and round((t.num_rows*t.avg_row_len)/1024/1024,0) !=0
0