Oracle import/export documentation

To export (import) the oracle import and export documents in detail, use % ORACLE_HOME %/db_1/BIN/exp.exe(imp.exe) to configure the environment variable path, and then directly use the exp command Export -------------------------------------------------------------------------------------------
· Export: export table, export scheme, Export Database exp command export, common options include: userid: Specifies the user name, password for executing the export operation, connection string tables: owner of the table to be exported: solution full-y: Database inctype to be exported: incremental type rows: data file in the table to be exported: specify the exported file name www.2cto.com export table ① export your own table exp userid = user name/password @ database instance name tables = (table name 1, table name 2) file = d: \ e1.dmp ② export tables of other schemes (at least dba permission is required, or exp_full_database permission is required) exp userid = system/manager @ orcl tables = (scott. emp) file = d: \ e2.dmp only exports the table structure (no data in it) exp userid = user name/password @ database instance name tables = (table name 1, table name 2) file = d: \ e1.dmp rows = n direct export (large data volume export, faster) exp userid = username/password @ database instance name tables = (table name 1, table name 2) file = d: \ e1.dmp direct = y www.2cto.com export scheme exp userid = username/password @ database instance name owner = (solution name 1, solution name 2) file = d: \. dmp exports all solutions in the database (at least dba permission is required, or exp_full_database permission is required) exp userid = username/password @ database instance name full = y inctype = complete file = d: \. dmpinctype = complete Incremental backup. During the second backup, only different parts are exported, which is faster to import. You can import the following table of other schemes to your own directory, however, make sure that the table to be imported does not have a foreign key dependency in the original solution. Import the table to the userid user import table to another user import table structure import data import table to userid user imp userid = username/ password @ database instance name tables = (table name 1, table name 2) file = d: \ e1.dmp user name refers to the user name to be imported, you can import tables in other scenarios to the user specified by userid (but the imported table cannot have a foreign key relationship) to other users (userid users must have dba permission or imp_full_database) imp userid = username/password @ database instance name tables = (table name 1, table name 2) file = d: \ e1.dmp touser = scott www.2cto.com import table structure imp userid = username/password @ database instance name tables = (table name 1) file = d: \ e1.dmp rows = n import data imp userid = username/password @ database instance name tables = (table name 1) file = d: \ e1.dmpignore = y import userid your own scheme www.2cto.com imp userid = username/password file = d: \ xxx. dmp import other schemes imp userid = user name/password file = d: \ xx. dmp fromuser = systemtouser = scott import database imp userid = username/password full = yfile = d: \ xxx. dm