I am a fan of DataPump in Network Mode. Typically I will execute something like the following,
impdp XXXX/XXXX@TARGET_DATABASE directory=dmpdir network_link=SOURCE_DB_LINK tables=TABLE1 TABLE2 TABLE3 remap_schema=DEVELOPMENT_SCHEMA:PROD_SCHEMA
I have a requirement to move a database to an environment where I do not have create privileges. Is it possible to use DataPump in Network Mode for this task?
That is the question. "Is it possible to use DataPump in Network Mode to move data from one database to another by specifying tables for inserting rather than specifying tables for creating and then inserting."
Thanks in advance.