Getting to know client-side import/export

In the past, data import and export were done on the client side. Before processing, a user session must be created, composing the data tunnel between the database server and the client. The select statement did the export, and the insert operation did the import. Regular communication was via the internet, which limited the approach due to the fidelity, network failures, and packets loss. Firstly, the processing time was strongly dependent on the network’s speed. Secondly, if the interconnection was not stable, the whole process would fail. After losing the connection, it was impossible to restore it and continue with the import or export process. The operation was aborted and needed to start once again from the beginning. Therefore, over time, client-side export (EXP) became obsolete and was replaced by server-side management. However, client-side import and export management principles still need to be covered and emphasized because...