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 WMay 13 at 11:45
Add a comment
|
1 Answer
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.
