Upgrade statistics in db
-- If we are importing stats table from higher version to lower version, then before importing in the database, we need to upgrade the stats table.
oracle configurationintermediate
by OracleDba
13 views
-- If we are importing stats table from higher version to lower version, then before importing in the database, we need to upgrade the stats table.
123
-- If we are importing stats table from higher version to lower version,
then before importing in the database, we need to upgrade the stats table.
EXECUTE DBMS_STATS.UPGRADE_STAT_TABLE(OWNNAME =>'RAJ',STATTAB =>'STAT_TEST');Please to add comments
No comments yet. Be the first to comment!