I have database that i want export from one machine and import into another machine using sqlplus on linux terminal.

I have tried nothing

  • sqlplus is for issuing commands, running scripts, invoking procedures, etc.. it is not for data loading or unloading. Data loading is done with SQL*Loader or external tables, data unloading is done with client libraries (not Oracle provided), and surgical data migration is done with expdp/impdp, or custom CTASs over dblinks, or even, if the OS is identical, just copy all the datafiles, redo log files, control files, etc... using OS copy commands (while the source DB is shut down, of course).
    – Paul W
    May 13 at 11:45

1 Answer 1


SQL*Plus is a wrong tool for that.

It is Data Pump you need: export (on source database) and import (on target database).

Oracle 21 documentation is here so - have a look.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.