How to make datapump apply directly to the destination schema 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.
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