Moving data from one oracle DB inside oracle to another.

If the databases can talk to one another directly you can use expdp or impdp across the network so you don't have to deal with the physical DMP file.  However, directly linking databases is a security issue.

If the databases are linked, there are a few other possibilities for moving tables and data but I would use export/import so I'll not mention them and confuse the question.

I'm not seeing the issue with export then import.  You can automate export, file transfer and import depending on the trust between the systems.

simple ? no
but you could build a script/program which instructs expdp/impdp to do all the necessary things

that way, if you need to repeat the task, you only need to start the script/program
or just schedule it

I need to come out of the corporate network to do an import.
In this case, how to link the db or automate export, file transfer and import.

If the databases cannot talk to each other across the network, you are pretty limited in your options.

>>automate export, file transfer and import.

I cannot answer that because I don't know your system.

Can your workstation see both databases at the same time?  Then you could use the classic exp/imp to export the file to your local workstation and import it into a remote database.

Automation of the export and import is pretty easy.  You can set up the database job inside the database or create parfiles and use OS scheduling to automate things.

Then all you need is to automate getting the file from point-A to point-B.  This is where we really  can't help because we don't know your systems.  I would look at sftp first.

Can your workstation see both databases at the same time?  >> No

Without direct network connectivity then you are limited in your automation options.

You need to figure out what options you have available to get the file from machineA to machineB.  We cannot help with that.

As far as automation, you might still be able to do this.  You can have a script/job/process running on machineB that monitors a specific file system.  When a file shows up it can trigger some process to take action on it.  That can be the import.

It is still automated just more complicated because you need disconnected processes running on two different machines.

I am manually taking the dump from target and use winscp to move to target file system.
In this case can this be automated.?

I'm not familiar with WinSCP but it does appear to have command line options.  If you can use the command prompt to copy/move the file to the remote server then I would say you can probably automate the export and getting the file to the new server.

https://winscp.net/eng/docs/commandline

You will need a different automated piece on the other server to perform the import once it arrives.