I work on an oracle db 11.2.0.4.0
I try to read number record of a schema.There are about 3.000 tables on this schema. I read that the classical statement
num_rows column in dba_tables is true for the data time of the last analyze. So I try script as :
select
table_name,
to_number(
extractvalue(
xmltype(
dbms_xmlgen.getxml('select count(*) c from '||table_name))
,'/ROWSET/ROW/C')) count
from user_tables;
show the list of table but when I try do go to the bottom this messagge popup:
ORA-19202: Error during elaboration XML
ORA-00942: table or view not exists
ORA-06512: a "SYS.DBMS_XMLGEN", line 176
ORA-06512: at line 1
I am not understand what is happen .
There are other way to do a report with the number of the records ?
Thanks in adavantage to anyone wants to answer.
Dan