Database Utilities (MOSC)

MOSC Banner

Clean DMU error on SYS.EXP_HEAD$ with dbms_stats.reset_col_usage

Hi

I'm using Database Migration Assistant for Unicode 19.1 on 19.17 database.

I'm trying to clean some error in SYS.EXP_HEAD$.

It's stated in Doc ID 2288522.1 (DMU reporting unconvertible data for EXP_HEAD$) that I should use dbms_stats.reset_col_usage to clean theses error.

I 'm abble to clean most error using this select to identify object on which to use dbms_stats.reset_col_usage:

SELECT OWNER,OBJECT_NAME,OBJECT_TYPE

FROM dba_objects

WHERE OBJECT_ID IN

  (SELECT UNIQUE OBJN FROM sys.EXP_HEAD$ WHERE rowid IN

     (SELECT row_id FROM system.dum$exceptions WHERE obj# =

     (select OBJECT_ID FROM dba_objects where OWNER='SYS' AND OBJECT_NAME ='EXP_HEAD$')))

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center