ORA-39083 ORA-00904（扩展统计信息）

ORA-39083: Object type TABLE:ZKM.TEST failed to create with error:ORA-00904: SYS_STUF3GLKIOP5F4B0BTTCFTMX0W: invalid identifier情况xx银行expdp11g——19c导入报错。扩展统计信息概念extension statistics处理可忽略直接事后在19c环境上面建扩展统计信息即可。1.查看col column_name for a50col DATA_DEFAULT for a50set line 500select COLUMN_NAME,DATA_DEFAULT,VIRTUAL_COLUMN,HIDDEN_COLUMN from dba_tab_cols where ownerZKM and table_nameTEST;2.建SELECT DBMS_STATS.CREATE_EXTENDED_STATS(OWNNAME ZKM,TABNAME TEST,EXTENSION (c1,c2)) FROM DUAL;模拟11g环境——————建用户、权限create user zkm identified by oracle;grant dba to zkm;建表CREATE TABLE zkm.test(c1 NUMBER(6),c2 NUMBER(8,2),c3 NUMBER(8,2));看ddl不用select dbms_metadata.get_ddl(TABLE,TEST,ZKM) from dual;建函数索引和普通索引比对create index zkm.test on zkm.test(NVL(c3,0));create index zkm.haha on zkm.test(c3);查看列col column_name for a50col DATA_DEFAULT for a50set line 500select COLUMN_NAME,DATA_DEFAULT,VIRTUAL_COLUMN,HIDDEN_COLUMN from dba_tab_cols where ownerZKM and table_nameTEST;建函数索引会出来一个虚拟列SYS_NC00004$普通索引不会。建扩展统计信息SELECT DBMS_STATS.CREATE_EXTENDED_STATS(OWNNAME ZKM,TABNAME TEST,EXTENSION (c1,c2)) FROM DUAL;查看列多出扩展统计信息的列select COLUMN_NAME,DATA_DEFAULT,VIRTUAL_COLUMN,HIDDEN_COLUMN from dba_tab_cols where ownerZKM and table_nameTEST;导入不一定报错但是确实扩展统计信息是没的