Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ impdp error ORA-39001, ORA-39000, ORA-31619     - SSH does not require a password to log on to a Linux server (Server)

- Docker - for the development and deployment of unified lightweight Linux containers (Linux)

- Spark read more HBase tables a RDD (Server)

- Port Telnet command to detect the remote host is turned on (Linux)

- Upgrading to MySQL 5.7 partitioning problem solving (Database)

- How to install the latest version of the Eclipse in Ubuntu 14.04 (Linux)

- Use CutyCapt to convert HTML pages to png images on Linux (Linux)

- Oracle 11g R2 RAC RMAN backup script example (Database)

- CentOS7 install NTFS-3G driver (Linux)

- Ubuntu How to install and upgrade Linux Kernel 3.15 (Linux)

- Use GNU / Linux broadcasting of television programs (Linux)

- Linux use additional rights (Linux)

- Update GAMIT10.6 command (Linux)

- Redis logging system (Database)

- KVM usb passthrough configuration (Linux)

- Talk about jsonp (Programming)

- How to Set Free SSH password on CentOS / RHEL (Linux)

- a virtual machine created migrated to host RHEL6.4 on Ubuntu 14.04 (Linux)

- RAID configuration and management under linux (Server)

- Linux see whether there is a hacker program (Linux)

 
         
  impdp error ORA-39001, ORA-39000, ORA-31619
     
  Add Date : 2018-11-21      
         
         
         
  Shortly before the Data Pump tool impdp data import encountered an error, suggesting invalid dunp files by querying the document because they do not know that this is due to the compatible version from high to low version of the cause, the following share solutions.

Import error

C: \ Documents and Settings \ hoegh> impdp hoeghto / ilovehoegh directory = data_pump_directory
 
dumpfile = 20150826dynamic.dmp remap_schema = hoeghfrom: hoeghto remap_tablespace = hoeghfrom: hoeghto

Import: Release 10.1.0.2.0 - Production on Tue, 01 Sep 2015 9:31

Copyright (c) 2003, 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

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d: \ data_pump_directory \ 20150826dynamic.dmp"

C: \ Documents and Settings \ hoegh>

The source database version

SQL> select * from v $ version;

BANNER

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

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL / SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

End target database version

SQL>
 
SQL> select * from v $ version;

BANNER

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

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL / SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

Add version parameter
The source database version 10.2.0.4.0, 10.1.0.2.0 version of the target-side database, the source database version is higher than the target-side database version; the solution is very simple, with the target end version when exporting data from the source database that is can, see what sql statement:

expdp hoeghfrom / ilovehoegh directory = data_pump_directory dumpfile = 20150826dynamic.dmp tables = (HOEGH) version = 10.1.0.2.0

Next, we execute impdp statement again ok.
     
         
         
         
  More:      
 
- Browser caching mechanism on the analysis (Linux)
- Linux, modify / etc / profile file (Linux)
- top command causes the system load increases (Linux)
- React Native (Programming)
- Linux System Getting Started Tutorial: How to change the default Java version in Linux (Linux)
- Udev: Device Manager for Linux Fundamentals (Linux)
- Android developers learning Adapter (data adapter) (Programming)
- Based AutoYaST automated installation of SUSE practice (Linux)
- Slow update statement Performance Analysis (Database)
- NET Developers need to know some Linux commands (Linux)
- CentOS 6.4 Python 2.6 upgrade to 2.7 (Linux)
- Seven kinds of DDoS attack methods and techniques Defensive (Linux)
- Linux itself disguised illusion strengthen security (Linux)
- Linux remote connectivity tools -OpenSSH (Linux)
- Tomcat installation under Linux (Server)
- Under Ubuntu 15.04 installation JDK8 (Linux)
- Ubuntu treated with cue file to ape and wav files automatically track points (Linux)
- MongoDB3.0.x version of the user authorization profile (stand-alone environment) (Database)
- Caffe install under Ubuntu 14.04 64bit (Linux)
- Migu online music player for Linux (Linux)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.