📋Steps in this guide1/1

Ger row_count of all the tables of a schema

select table_name, to_number(extractvalue(dbms_xmlgen.getXMLtype('select /*+ PARALLEL(8) */ count(*) cnt from "&&SCHEMA_NAME".'||table_name),'/ROWSET/ROW/CNT')) rows_in_table from dba_TABLES where owner='&&SCHEMA_NAME';

oracle configurationintermediate

by OracleDba

11 views

Ger row_count of all the tables of a schema

Code/Command (click line numbers to comment):

select table_name,
to_number(extractvalue(dbms_xmlgen.getXMLtype('select /*+ PARALLEL(8) */ count(*) cnt from "&&SCHEMA_NAME".'||table_name),'/ROWSET/ROW/CNT'))
rows_in_table from dba_TABLES
where owner='&&SCHEMA_NAME';

Comments (0)

Please to add comments

No comments yet. Be the first to comment!