How to transfer data from one oracle database to another?

Question

Oracle

Hello!
There is a task to transfer the data from one base to another. I warn you right away - I have never been a dba at all, and I have never dealt with oracle administration.
Initial data Database on a remote machine ( access
via vpn) oracle 11g2 - let's call it "source" database
Second database - oracle xe 11g - also on a remote machine (access via ssh) - let's call it "target"
2nd base.
There is no way to reach the source database from the target one - there is no way to configure vpn.
There is no access to the server where the original database is running, as well as a dba account, as well as a ready-made dump.
So - an attempt to solve the problem: Using sql developer - export the schema (in the form of a script with inserts) to the developer's wheelbarrow, then copy the script to the target machine and execute the script using sqlplus. The procedure is very long. I have no idea if this number will work or not.... I don't know any other options.
The question is this - are there any other simpler ways to transfer data from one database to another?

Answer 1

Google datapump.
Another option is Sqldeveloper , which can copy entire schemas. Tools -> Database Copy. Choose where and where. Then what objects to transfer and what to do with the objects in the scheme where you copy.
In this case, you need to create the scheme where you will copy it yourself.
Both options have been personally tested and both work. The second one is much longer in time, but definitely faster than doing export / import by hand.