Demonstration of Oracle IMP import process

Import the Oracle Import utility (Import utility) allows Oracle to extract some data from the relevant database and store the data in the relevant files. The following articles demonstrate common methods of imp in imp format. The following describes the specific content of the article.

1. Get help

Imp help = y

2. Import a complete database

Imp system/manager file = bible_db log = dible_db full = y ignore = y

3. import one or more specified tables, indexes, and other objects to which the user belongs.

Imp system/manager file = seapark log = seapark fromuser = seapark imp

System/manager file = seapark log = seapark fromuser = (seapark, amy, amyc, harold)

4. Import utility in Oracle allows you to extract data from a database and Import the 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 a table

Imp system/manager file = tank log = tank fromuser = seapark TABLES = (a, B)

6. Import 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

Bible_tables.par parameter file:

# Import the sample tables used for the Oracle8i Database Administrator's

Bible. fromuser = seapark touser = seapark_copy file = seapark log = seapark_import

8. import data in incremental Mode

Imp system./manager inctype = rectore full = y file =

Oracle imp/exp

C: Documents and Settingsadministrator> exp help = y

The above is an introduction to the Oracle Import utility that allows you to extract data from the database and write data into the operating system file.