Oracle export and import under the DOS command

Oracle export and import under the DOS command

The command running in DOS can also be run with parameters in the SQL/PLUS Environment
Simple Example

Single Table backup (the structure of the prerequisite database is the same)
Export:
Start button-> Run-> Enter CMD-> enter the DOS Interface
EXP username/password @ connection string GRANTS = y tables = (stu) file = C: \ file name. DMP
Import:
Start button-> Run-> Enter CMD-> enter the DOS Interface
IMP username/password @ connection string IGNORE = y tables = (stu) FULL = N file = C: \ file name. DMP

Stu is the name of the table you want.

Full Database Import
Export:
Start button-> Run-> Enter CMD-> enter the DOS Interface
EXP username/password @ connection string FULL = Y file = C: \ file name. DMP
Import:
Start button-> Run-> Enter CMD-> enter the DOS Interface
IMP username/password @ connection string FULL = Y file = C: \ file name. DMP

You can do this by importing the entire database.

Use an instance (oracle 9i)
-- Create and authorize a user
Create user Username identified by password;
Grant connect, resource, dba to user name;
-- Export by user
Exp username/password @ database name owner = username file = absolute path (D: \ test. dmp)
-- Import by user
Imp username/password @ database name file = absolute path (D: \ test. dmp) full = y;