DBA Hub

📋Steps in this guide1/1

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
1

Upgrade statistics in db

Code/Command (click line numbers to comment):

1
2
3
-- 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');

Comments (0)

Please to add comments

No comments yet. Be the first to comment!