Oracle Import and Export

Export (import)% ORACLE_HOME %/db_1/bin/exp.exe(imp.exe)
You can configure the environment variable path and then directly use the exp command.

Bytes -------------------------------------------------------------------------------------------

· Export: Export tables, export solutions, and export Databases
Export The exp command. Common options include:
Userid: Specifies the username, password, and connection string used to execute the export operation.
Tables: Table to be imported
Owner: solution to be imported
Full-Y: database to be exported
Inctype: incremental type to be exported
Rows: data in the table to be exported
File: Specifies the name of the exported file.

Export table
① Export your own table

Exp userid = username/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

 

Export only the table structure (no data in it)
Exp userid = username/password @ database instance name tables = (table name 1, table name 2) file = D: \ e1.dmp rows = N

 

Direct Export (export of large data volumes, faster)

Exp userid = username/password @ database instance name tables = (table name 1, table name 2) file = D: \ e1.dmp direct = y

 

Export Scheme
Exp userid = username/password @ database instance name owner = (solution name 1, solution name 2) file = D: \ A. dmp

 

Export 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: \ A. dmp
Inctype = complete Incremental backup. During the second backup, only different parts are exported, which is faster.

Import: You can import the tables in other schemes to your own directory, but make sure that the imported table has no foreign key dependency in the original scheme.

Bytes -------------------------------------------------------------------------------------------

· Import
Import table to userid user
Import tables to other users
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 to. You can import tables in other schemes to the user specified by userid (but the table to be imported cannot have a foreign key relationship)

 

Import tables to other users (userid users must have DBA permissions or imp_full_database)

IMP userid = username/password @ database instance name tables = (table name 1, table name 2) file = D: \ e1.dmp touser = Scott

 

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

 

Solution for importing userid

IMP userid = user name/password file = D: \ XXX. dmp

 

Import other solutions

IMP userid = username/password file = D: \ XX. dmp fromuser = systemtouser = Scott

 

Import Database

IMP userid = username/password full = yfile = D: \ XXX. DM