Oracle export and import under the DOS command, oracledos command Export
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;
How to Use the DOS command to import and export oracle databases
Export command exp and import command imp.
Specific parameters are available. Check them yourself.
Oracle export database commands in dos
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