exporting from 11.2 to 18C, did full import first to set new DB up, then following with schema level import for future updates.
All the tables in the schema being imported go okay but 3 tables, which get an error:
ORA-39083: object_type TABLE:"<schema>"."<table_name>" failed to create with error:
ORA-00904: "SYS_STSFXRUD_XMMRAS99BZ3MCLK$9": invalid identifier
Failing sql is:
ALTER TABLE "<schema>"."<table_name>" MODIFY ("SYS_STSFXRUD_XMMRAS99BZ3MCLK$9" NUMBER GENERATED ALWAYS AS (SYS_OP_COMBINED_HASH("PRODUCT_CLASS_TYPE","ACTIVE")) VIRTUAL )
The ORA-00904 is different for each table, and the failing sql references a couple of columns in each table, which are all varchar2 columns, nothing out of the ordinary.
All 3 tables are actually created, and have correct data in them.
If I drop each table and re-import that table only from the same dump file, they import without a hitch, no errors at all.
I am wondering what is causing this, and if it can be ignored. When I output the import into a sqlfile it looks like the import does a lot of sql pertaining to stats, so I tried the import schema again (after dropping it) with no statistics but still got the same errors.
update - when I look at the table columns from USER_TAB_COLS, it appears these three tables have a hidden column, which hashes the 2 columns mentioned in the failing SQL, so it appears like someone created extended stats for these tables. I still don't know why the table import perfectly fine on their own though.
Suggestions?
thanks in advance.