1 person found this helpful
seems it is not supported for Network link check this: Ref Doc:DBMS_DATAPUMP
DATA_REMAPprocedure is only supported for Export and Import operations. It allows you to manipulate user data being exported or imported. The
nameof the remap determines the remap operation to be performed.
I haven't try this but, are you using the same user/schema name for the data pump operation where your object exist.. if not you can try this option as well. in that case NULL support i believe.
For future, you can unmark your questions and make then unanswered - FYI
I was using different schema as target (METADATA_REMAP/REMAP_SCHEMA, source schema name is implying production so the schema name should be changed).
I tried using same schema as both source and target, no REMAP_SCHEMA and now DATA_REMAP works when I give SOURCE_SCHEMA as schema parameter.
NULL is still not accepted but that does not matter anyway.
So the actual problem is, data remap will not happen if
- import from db link and
- schema remap
Srini: How can I mark "assumed answered" as Not answered? I am probably missing something obvious but I am not the only one: How to reset a thread back to unanswered in OTN forum?
(this question is Not answered)
Good question - I have seen it being done - so assumed it was do-able - but I am not able to reproduce it in a test forum. Quite possibly that option was removed recently as the options on these forums continue to evolve