How to copy a table between two databases in Oracle

How to copy a table between two databases in Oracle

Very often there is a need to test a scenario that executes on production. We can use for such task lower environment (if we have any) or we can try to mimic this on our own local machine. To do this we have to prepare everything as close to the original environment as possible. If you are using the Oracle database you would like to prepare test data on your local database. Here is one solution that can help you in preparing a local copy of production data fast.
In this tutorial, we will use Docker image as a local Oracle database and connect from inside Docker container to an external database using HAProxy tool.

Diagram that shows client connection to Oracle Container and connection between Docker container to External Oracle DB via local HAProxy - How to copy Oracle table
Connection from Oracle DB that is inside Docker container to an external database
Czytaj dalej „How to copy a table between two databases in Oracle”