Oracle Import and Export DMP file

Mesh Record

Directory ... 3

1 description ... 3

2 Exporting DMP files ... 3

3 Importing DMP files ... 5

3.1 Environment Preparation ... 5

3.2 Performing import ... 6

1 description

DMP files are data backup files for Oracle database, execute Oracle Database export DMP files, equivalent to perform database backup, execute import DMP file, equivalent to database restore.

2 Exporting DMP files

Execute the following commands under the DOS console:

Su-oracle

Exp Iflashbuy/[email protected] file=iflashbuy20140121.dmp owner=iflashbuy246

which

Username for user//Export database table space

Password//corresponding password

ORCL//Database service name (SID)

File//exported DMP file storage path

During execution, the console outputs:

Export:release 10.1.0.2.0-production on Monday April 9 15:16:33 2012

Copyright (c) 1982, 2004, Oracle. All rights reserved.

Connected to:oracle Database 10g Enterprise Edition Release 10.1.0.2.0-produc

tion

With the partitioning, OLAP and Data Mining options

Export done in ZHS16GBK character set and Al16utf16 NCHAR character set

. Exporting Pre-schema procedural objects and actions

. Exporting foreign function library names for user MEDICINE

. Exporting public type synonyms

. Exporting private type synonyms

. Exporting object type definitions for user MEDICINE

About-to-export MEDICINE ' s objects ...

. Exporting database Links

. Exporting sequence Numbers

. Exporting cluster definitions

. About to export MEDICINE ' s tables via conventional Path ...

. . Exporting table Certificateverrelation rows exported

. . Exporting table Enterpriseaptitudesverrelation 4 rows exported

. . Exporting table Sellapproveconfig 0 rows exported

. .......

. Exporting synonyms

. Exporting views

. Exporting stored Procedures

. Exporting operators

. Exporting referential integrity constraints

. Exporting triggers

. Exporting indextypes

. Exporting bitmap, functional and extensible indexes

. Exporting Posttables Actions

. Exporting materialized views

. Exporting snapshot logs

. Exporting job queues

. Exporting refresh groups and children

. Exporting dimensions

. Exporting Post-Schema procedural objects and actions

. Exporting statistics

Export terminated successfully without warnings.

3 Importing DMP Files 3.1 Environment preparation

Using the SYS user, log in to the Oracle database's EM with the DBA role, create a tablespace, and access the user name for the tablespace, and give the user the following roles:

1) Connect

2) DBA

3) Exp_full_database

4) Imp_full_database

5) RESOURCE

and give the following permissions

3.2 Performing the Import

Under System console input:

IMP User/[email protected]

which

user--the user name of the database table space

psw--the password for the database table space

sid--database service name (SID)

After execution, the form prompts for the DMP file path:

After entering the DMP file path, the following prompt options use the default values, as follows:

3.3 Instruction Interpretation

1) Imp User/[email protected] execute the import instruction;

2) Expdat. DMP > Hint input dmp file path;

3) Enter Insert buffer size (min is 8192) 30720: Tip minimum set to 8192, recommended setting 30720, can use 30720;

4) List contents of import file only, prompt to enter No.

5) The following 4 inputs, all using the default values;

6) Username: Enter the user name of the exported DMP file so that all table objects associated with the user name will be imported;

7) If done: input enter;

8) Perform import ...

Note: Objects already in the database, do not overwrite when performing the import, prompt the object already exists and execution failed error, enter as follows:

4 Precautions 4.1 Database recovery operation in Linux environment

You cannot log on to remote Linux for database recovery and backup via SSH, and you must perform database recovery and backup on the terminal of the Linux system via Remote Desktop.

5 Installation problems:

Bout to export specified users ...
. Exporting Pre-schema procedural objects and actions
. Exporting foreign function library names for user iflashbuy
. Exporting public type synonyms
. Exporting private type synonyms
. Exporting object type definitions for user Iflashbuy
About-to-export iflashbuy ' s objects ...
. Exporting database Links
. Exporting sequence Numbers
. Exporting cluster definitions
Exp-00056:oracle Error 1652 encountered
ORA-01652: Unable to extend temp segment by @ tablespace temp
Exp-00000:export terminated unsuccessfully

Cause: Temporary table space is not enough