Home IT Linux Windows Database Network Programming Server Mobile  
  Home \ Database \ Nonstandard IMP-00010 error processing one case     - Installation configuration CUDA under Ubuntu 14.04 (Linux)

- RPM package fabrication method (Linux)

- Development environment to build MEAN In Ubuntu 15.10 (Server)

- Number JavaScript type system (Programming)

- Binary tree traversal recursive and non-recursive (cyclic) traversal achieve (Programming)

- Grub2: Save Your bootloader (Linux)

- Ceph performance optimization summary (v0.94) (Server)

- Simple Calendar C language (Programming)


- Linux Network Security Tips Share (Linux)

- MySQL5.7 JSON type using presentation (Database)

- How to update the ISPConfig 3 SSL Certificates (Server)

- Java inheritance initialization problem (Programming)

- for (int a: i) the use of the Java programming (Programming)

- DataGuard add temporary data files bug (Database)

- RedHat install GCC problem --- Depends (Linux)

- Installation on the way to the root source Ubuntu Server 14.04 LTS version Odoo8.0 (Server)

- apt-get and apt-cache show command examples (Linux)

- Linux-- sub-volume compression and decompression (Linux)

- CentOS 6.4 RPM install MySQL-5.6.22-1 (Database)

  Nonstandard IMP-00010 error processing one case
  Add Date : 2017-04-13      
  Exp / it is called the Oracle product family classic, popular for its ease of use in the technical staff. Although from the beginning 10g, Oracle Data Pump to gradually replace its use as a data backup and restore tool for small-scale logic, but Exp / Imp for the average developer is quite attractive.

One of the advantages of using Exp / Imp from a technical point of view, the client is running, use do not need to connect to the database server, you can easily perform data backup and restore operations. Imagine DBA will not easily allow people to log sensitive Oracle server machine.

1, gossip Exp / Imp

Exp / we often encountered in practice in the field are two problems: one is the character set conversion, and the other is a client / server version coordination. Character set conversion is rooted in the diversity of client software, which requires each use Exp / Imp, we both need to show nls_lang set environment variables, the only way to ensure proper export and import data characters. Note: Many developers prefer to use PL / SQL Developer in the exp / imp tool, in fact, a disguised call Oracle client executable program, this approach is no way to set the parameters nls_lang, will encounter a lot of trouble.

Client / server version coordinating more trouble. Use exp / imp tools for backup and restore, which involves four software version of the problem, namely the export version of the source database, export exp client version, import target database version and import imp client version. High version of the Export client dmp file generated in the low import into the client version when it is not compatible. So, whether it is a complex matrix Oracle MOS official, or a network of people heroes cow articles are listed, to indicate the correspondence between the four versions of the software.

Theoretically, if a violation of the principles of software compatibility, the exported dmp file is not successfully imported. We need to re-export operations planning, too much trouble. In this paper, the author records an unconventional strategy to solve the compatibility problem cases, left to "desperate" friends "rainy day."

2, import IMP-00010 error

The author is the source database 11gR2, we need to demonstrate a data schema into another server. Due to the relatively long time, we have forgotten the version number of the target database. I think that it should be granted the 11gR2 Oracle, then use the tool to export Exp.

For simple habit, we run the exp command on the server, so export database and the client are 11gR2.

Until the time of import data, there is a problem.

D: \ DDD> imp \ "/ as sysdba \" file = DDD_TESTING_20150901_exp.dmp fromuser = ddd_testing touser = ddd_testing

Import: Release - Production on Wed Sep 2 22:36:31 2015

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

Connected to: Oracle Database 10g Enterprise Edition Release - Produc


With the Partitioning, OLAP and Data Mining options

IMP-00010: not a valid export file, header failed verification

IMP-00000: Import terminated unsuccessfully

Header does not recognize this problem in general there are two possibilities: one is the file bad block occurs, there is a problem in the FTP download or copy from the copy process. Another version compatibility issues.

If the first question is, in theory, there is no other way, only to re-export or download dmp file. If the problem is a compatible version, you need to check the target database and import client situation.

SQL> select * from v $ version;


-------------------------------------------------- --------------

Oracle Database 10g Enterprise Edition Release - Prod

PL / SQL Release - Production

CORE Production

TNS for 32-bit Windows: Version - Production

NLSRTL Version - Production

Import target is 10g, and the client also 10gR2. This presents compatibility issues, the low version of the client "is considered" high version can not be resolved to understand client generates a file, it will refuse to import error. Displays information is not verified by the file header.

3, atypical treatment

I basically had no choice this time. Only to go back to re-export the data content with a low end version of the client, or select Data Pump version performed adjustment process. But on the web, I found a plausible approach.

Not compatible Exp / Imp version of the phenomenon, Oracle Dmp file for content restrictions in nature. Because, Oracle worried about the low version of Imp program, you can not understand the high version Dmp file generated inside the content and objects, will have restrictions. I Dmp package which only data tables and indexes some ordinary objects, the "Advanced" object that is not, in fact, this restriction does not make sense.

So, just to make minor modifications to the file header, so that clients can lower version 10gR2 "approved" Dmp files just fine. According to this idea, the notepad ++ editor download from the network, directly open Dmp file. Note: This process is actually at risk, will approximate Dmp binary file in text format open, to have a certain psychological preparation.

After opening the file, you can see the file header information, clearly marked with the Dmp file version 11gR2 content.

Be amended to adapt 10gR2 number V10.02.01, after saving.

After you save the same program calls the import command to import the normal start.

D: \ DDD> imp \ "/ as sysdba \" file = DDD_TESTING_20150901_exp.dmp fromuser = dd_testing touser = dd_testing

Import: Release - Production on Wed Sep 2 22:47:50 2015

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

Connected to: Oracle Database 10g Enterprise Edition Release - Produc


With the Partitioning, OLAP and Data Mining options

Export file created by EXPORT: V10.02.01 via conventional path

import done in ZHS16GBK character set and AL16UTF16 NCHAR character set

export client uses AL32UTF8 character set (possible charset conversion)

. Importing UAT_TESTING's objects into UAT_TESTING

.. Importing table "Aa" 0 rows imported

.. Importing table "d" 0 rows imported

.. Importing table "d" 134 rows imported

(Space reasons, have omitted ......)

.. Importing table "f" 0 rows imported

.. Importing table "Xd" 0 rows imported

About to enable constraints ...

Import terminated successfully without warnings.

Import operation simple comparison worrying only start restraining order. Check the table and index data objects to determine the import was successful.

SQL> select count (*) from dba_indexes where owner = 'DD_TESTING';




Fortunately, also a test environment, data, constraints, and index objects will be enough, to achieve the goal.

4 Conclusion

I approach, in fact there is a big risk and hazards. On the usual test environment, select temporary failure remediation strategies still acceptable. If it is a formal environment, must operate in accordance with specifications, through the realization of the test to predict the risk of problems, design solutions, it is important to ensure that all objects can be smoothly introduced.

In addition, the author of this method is in fact contrary to the principles of Oracle, if there are some new features of the object author dmp file or version very different, we can not guarantee the smooth import operation.
- Delegate in C # (Programming)
- Netcat Example (Linux)
- Cygwin install Python MySQLdb (Linux)
- Linux_Logo - output color ANSI Linux distributions logo command-line tool (Linux)
- Spring classic face questions Share (Programming)
- VMware installed Linux system and JDK deployment (Linux)
- How to download apk file from the Google Play store on Linux (Linux)
- Inherent limitations of Linux systems network security (Linux)
- Use Visual Studio to compile and use WinGDB remote debugging embedded Linux programs (Programming)
- redis main building and disaster recovery from a cluster deployment (Database)
- HashMap in Android and Java different implementations (Programming)
- Linux use glibc2 library and crypt () function to generate the user password (Programming)
- Oracle 12C RAC on temporary table space Enlighten (Database)
- To build PHP environment (Nginx + MariaDB + PHP7) under CentOS 6.5 (Server)
- Linux Getting Started tutorial: Ubuntu 14.04 in the installation Sogou Pinyin (Linux)
- To convert into a binary search tree sorted doubly linked list (Programming)
- Python2 ---- function using dictionaries (Programming)
- How to set up HTTPS policies for older browsers (Server)
- How do I delete a NEEDS RECOVERY rollback state of undo tablespace (Database)
- Whisker Menu 1.4.3 Install menu Linux (Linux)
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.