Eight common imp usage examples in Oracle Data Import

After learning about Oracle for a while, we may encounter Oracle data import problems. Here, we will briefly introduce some Oracle data import methods and share them with you. The Oracle Data Import utility allows you to extract data from a database and write the data to an operating system file. The basic format used by imp: imp [username [/password [@ service]. The following describes common usage of imp.

1. Get help imp help = y

2. Import Oracle data into a complete database imp system/manager file = bible_db log = dible_db full = y ignore = y

3. Import Oracle data to one or more tables, indexes, and other objects that specify the user's location
Imp system/manager file = seapark log = seapark fromuser = seapark imp
System/manager file = seapark log = seapark fromuser = (seapark, amy, amyc, harold)

4. Import Oracle data of one user to another
Imp system/manager file = tank log = tank fromuser = seapark touser = seapark_copy
Imp system/manager file = tank log = tank fromuser = (seapark, amy)
Touser = (seapark1, amy1)

5. Import Oracle data into a table
Imp system/manager file = tank log = tank fromuser = seapark TABLES = (a, B)

6. Import Oracle data from multiple files
Imp system/manager file = (paycheck_1, paycheck_2, paycheck_3, paycheck_4)
Log = paycheck, filesize = 1G full = y

7. Use the parameter file
Imp system/manager parfile = bible_tables.par
Import the sample tables used for the Oracle8i Database Administrator's
Bible. fromuser = seapark touser = seapark_copy file = seapark log = seapark_import

8. incremental Import
Imp system./manager inctype = rectore full = y file =

Importing and exporting Oracle Data imp/exp is equivalent to restoring and backing up oracle data. The exp command can export data from the remote database server to the local dmp file, and the imp command can import the dmp file from the local to the distant database server. This function can be used to build two identical databases, one for testing and the other for formal use.

Execution Environment: In SQLPLUS. execute in EXE or DOS (command line). When DOS can be executed, the \ ora81 \ BIN directory in oracle 8i is set to a global path, and EXP exists in this directory. EXE and IMP. the EXE file is used for import and export. Oracle is written in java. SQLPLUS. EXE, EXP. EXE, and IMP. EXE files may be packaged class files. SQLPLUS. EXE calls the classes encapsulated by EXP. EXE and IMP. EXE to import and export Oracle data.

1. Oracle Data Import imp/exp practices
2. Performance Optimization Strategies for Oracle databases in the design and development phase
3. Introduction to three basic Oracle Data Types
4. Solution to accidental deletion of Oracle Database Files
5. Understanding of Oracle Database Character Set