Oracle – How to Make Data Pump Apply Directly to the Destination Schema

migrationoracleoracle-11g-r2

I have a schema on a server that returns and half I need to replicate it to another server, so I'll la and do an expdp on server1 sending the file to server2 and do an impdp. Solve the problem.

However, I wanted to know if I can not do the expdp and generate the file, but do an impdp directly on the destination without generating the file.

That would save a lot of time.


Original question on SoPT – Como fazer datapump aplicar diretamente no schema destino
Translated by translate.google.com.

Best Answer

Using Network Link Import to Move Data

When the Import NETWORK_LINK parameter is used to specify a network link for an import operation, SQL is used to move the data using an INSERT SELECT statement. The SELECT clause retrieves the data from the remote database over the network link. The INSERT clause uses SQL to insert the data into the target database. There are no dump files involved.

NETWORK_LINK

Related Question