Database Utilities (MOSC)

MOSC Banner

Inquiry Regarding Impdp Errors During Oracle 12c to 19c Data Migration

I used DataPump to migrate data from Oracle 12c to 19c, but one import (Impdp) failed due to the following error:

CRETA2.PK_APP_EMPLOYEE : sqlerrm = ORA-20000: Unable to set values for index PK_APP_EMPLOYEE: does not exist or insufficient privileges.
Importing statistics failed for 1 object(s);

I have attached the Impdp log. Upon reviewing the source file, I did not find any empty or duplicate SUIDs.
If you are aware of any related cases or potential causes, I would greatly appreciate your guidance.

DataPumpを使用して、Oracle 12c から 19c にデータ移行を行いましたが、以下のエラーにより一つのインポート(Impdp)が失敗しました。

CRETA2.PK_APP_EMPLOYEE : sqlerrm = ORA-20000: Unable to set values for index PK_APP_EMPLOYEE: does not exist or insufficient privileges

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