How to import a command from Oracle

In practical applications, we can feel that Oracle is quite powerful and flexible. If you want to use Oracle as a database of your project, but you do not know how to import the database, you can refer to the following articles to understand the actual operation steps of Oracle import.

Import IMP from Oracle

The Oracle 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 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 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. You need to import a table to Oracle import IMP.

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

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

Oracle imp/exp

C: Documents and Settingsadministrator> exp help = y

Export: Release 9.2.0.1.0-Production on

Copyright (c) 1982,200 2, Oracle Corporation. All rights reserved.

By entering the EXP command and user name/password, you can use the command with the user name/password:

Routine: exp scott/TIGER

Alternatively, you can enter the EXP command with various parameters to control "Export" based on different parameters. To specify parameters, you can use the Keyword:

Format: exp keyword = value or KEYWORD = (value1, value2,..., valueN)

Routine: exp scott/tiger grants = y tables = (EMP, DEPT, MGR)

Or TABLES = (T1: P1, T1: P2). If T1 is a partitioned table, USERID must be the first parameter in the command line.

The above is an introduction to the actual operation steps of the Oracle import utility. I hope you will gain some benefits.