DBMS_STATS.GATHER_SCHEMA_STATS

How to Resolve ORA-20000: Insufficient privileges to analyze an object in Schema

by Ed Chen
June 20, 2023August 25, 2023

ORA-20000 A normal user can analyze its own schema without problem, but it cannot analyze other's schema. If do it, ORA-20000 will be thrown. Let's… Read More »

How to Compare Two Databases After Migration (2/3) - Comparing Row Counts by Leveraging Statistics

by Ed Chen
December 24, 2012June 6, 2023

How to Compare Two Databases After Migration (1/3) - Comparing Initialization Parameters After a data migration, you might want to compare the number of rows… Read More »

JavaScript is not enabled. Please enable it and reload the page.