Data pump import (Append) failed even SKIP_CONSTRAINT_ERRORS is set
Hi! Our customer is running Oracle 12c (12.2) Enterprise Edition on HP-UX 11.31.
We have exported data from one table and restore to another one with the same structure but different table name. We add data_options=SKIP_CONSTRAINT_ERRORS to the import parameter because there may exist records on the destination table and we do not want the other imported rows rollback. However, it was not successful. Could someone point out what wrong in our case? Below is the import log.
;;;
Import: Release 12.2.0.1.0 - Production on Tue Jan 7 12:00:25 2020
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
0