Re: Exact table count for all tables in a schema.
Again with a transactional engine, "actual" can be just an estimate.
select sum(table_rows)
from information_schema.tables;
Subject
Views
Written By
Posted
2267
September 13, 2019 01:53AM
1063
September 13, 2019 09:43AM
986
September 16, 2019 11:15PM
Re: Exact table count for all tables in a schema.
721
September 17, 2019 10:07AM
803
September 19, 2019 12:24AM
764
September 19, 2019 09:38AM
821
September 20, 2019 04:04AM
643
September 20, 2019 09:50AM
1014
September 20, 2019 10:03AM
1073
September 20, 2019 12:45PM
712
September 22, 2019 11:51PM
926
September 23, 2019 10:21AM
778
September 24, 2019 10:45PM
743
September 25, 2019 11:01AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.