DOS Run command, can also add parameters in the Sql/plus environment to run
Simple example implementation
Single-table backup (the structure of the premise library is the same)
Export:
Start button, run-and input cmd-> into the DOS interface
EXP User name/password @ connection string grants=y tables= (stu) file=c:\ file name. CM7
Import:
Start button, run-and input cmd-> into the DOS interface
IMP username/password @ connection string ignore=y tables= (stu) full=n file=c:\ file name. CM7
Where Stu is the name of the table you want
Full Library Guide
Export:
Start button, run-and input cmd-> into the DOS interface
EXP User name/password @ connection string full=y file=c:\ file name. CM7
Import:
Start button, run-and input cmd-> into the DOS interface
IMP username/password @ connection string full=y file=c:\ file name. CM7
The situation you are talking about will be done by the whole library.
Use instances (Oracle 9i)
--Create user and authorize
Create user username identified by password;
Grant CONNECT,RESOURCE,DBA to user name;
--Export by user
EXP User name/password @ database name owner= user name file= absolute path (D:\\TEST.DMP)
--Import by user
IMP username/password @ database name file= absolute path (d:\\test.dmp) full=y;
Original: http://www.2cto.com/database/201409/338485.html
Oracle Export Import under DOS command