I am doing a full datapump import from one database to another. Both databases version are 12.1.0.2. I got the error "ora-39083 object type table:". It failed to create the partitioned table below:
SQL> desc edb.calculation_flag_bk
Name Null? Type
----------------------------------------- -------- ----------------------------
CALCULATION_FLAG_ID NOT NULL NUMBER
CALCULATION_ID NOT NULL NUMBER
CALCULATION_FLAG_TYPE_ID NOT NULL NUMBER
CREATE_DT NOT NULL DATE
CREATE_USER_ID NOT NULL NUMBER
MODIFY_DT DATE
MODIFY_USER_ID NUMBER
EFFECTIVE_DT DATE
INACTIVE_DT DATE
FLAG_ID NOT NULL NUMBER