I. Description
The oracle exp/imp command is used to export/import databases;
The exp command is used to export data from a remote database server to a local machine to generate a dmp file;
The imp command is used to import the dmp file of the local database from the local database to a remote Oracle database.
II. The following describes the Import and Export instances.
Data export:
Exp myname/mypassword@192.168.100.152/orcl file = d: \ my. dmp -- export database fully exp myname/mypassword@192.168.100.152/orcl file = d: \ my. dmp full = y -- export only the table exp myname/mypassword@192.168.100.152/orcl file under user myuser = d: \ my. dmp owner = (myuser) -- export only test1, test2 table exp myname/mypassword@192.168.100.152/orcl file = d: \ my. dmp tables = (test1, test2)
Data Import:
-- Import imp myname/mypassword@192.168.100.152/orcl file = d: \ my. dmp full = y -- import all, ignore existing data imp myname/mypassword@192.168.100.152/orcl file = d: \ my. dmp full = y ignore = y -- import only test1 test2 table imp myname/mypassword@192.168.100.152/orcl file = d: \ my. dmp tables = (test1, test2)
Only one of the owner and tables can be specified during exp export.
Otherwise, an error is reported.
EXP-00026: Conflict mode specified
EXP-00000: Export termination failed
You can specify either full or tables during imp import.
Otherwise, an error is reported.
IMP-00024: only one mode (TABLES, FROMUSER, or FULL) IMP-00000 can be specified. IMP-: Import failed. PS: The command is briefly described. There are many parameters, the basic requirements can be fulfilled. For details, refer to relevant materials.