Nope. If REMAP_SCHEMA doesn't work, that's it. You can, however,
pre-create the with the proper definition and then use
TABLE_EXISTS_ACTION=APPEND. That, however, could lead to another problem
since the newly created sequence will start from the beginning, whatever
START WITH option of the CREATE SEQUENCE command has specified, so the
rows from the original table will very likely differ from the imported
rows. Let me discover the hot water and tell you that you're in a
pickle. Good luck.
On 7/26/21 6:03 AM, Thomas Kellerer (Redacted sender thomas.kellerer for
DMARC) wrote:
So my question is:
Is there any way to tell DataPump to replace the reference to "THOMAS"."MY_TABLE_ID_SEQ" with the
target schema: "ARTHUR"."MY_TABLE_ID_SEQ"?