Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ exp / imp Export Import version of the problem and the ORA-6550 error     - Process monitoring tools Supervisor start MongoDB (Database)

- MySQL my.cnf sql_mode schema modifications (Database)

- Ubuntu Gnome and Fedora 22 Gnome desktop, extended to achieve global menu (Linux)

- Linux server disk expansion and Oracle tablespace file migration operations (Database)

- Design and implementation of environment sniffer running under Linux (Linux)

- RHEL5 stalled due to power service error system can not start (Linux)

- The Zabbix2.4.5 source compiler installation under Ubuntu 14.04 (Server)

- How to create a someone project on github (Linux)

- MySQL loose index scan (Database)

- How to use SVN to manage our source code (Server)

- Usage Linux device tree (Programming)

- Graphing tool: Gnuplot (Linux)

- CentOS7 iptables (Linux)

- Ubuntu deployed under regular tasks with crontab (Linux)

- Linux Learning Notes: Users and Groups (Linux)

- The Java Properties class action (Programming)

- How to install and use the Snort in Ubuntu 15.04 (Linux)

- To generate a certificate using OpenSSL under Linux (Server)

- Android official recommendation: DialogFragment create dialog (Programming)

- HTTP and FTP TCP-FLOOD CC Attacks Analysis and Prevention solutions under CentOS 6.5 (Linux)

 
         
  exp / imp Export Import version of the problem and the ORA-6550 error
     
  Add Date : 2018-11-21      
         
       
         
  A few days ago a colleague asked exp / imp whether related to the version of the problem, I think, as long as the software, will involve the level of version compatibility issues, Oracle software is, naturally, too.

Simple experiment:

exp Tool Version: 10g

Export source database version: 9i

bash-4.1 $ exp x / x @ x tables = T file = / home / x / t.dmp

Export: Release 10.2.0.4.0 - Production on Wed Dec 11 15:17:05 2013

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

EXP-00056: ORACLE error 6550 encountered

ORA-06550: line 1, column 41:

PLS-00302: component 'SET_NO_OUTLINES' must be declared

ORA-06550: line 1, column 15:

PL / SQL: Statement ignored

EXP-00000: Export terminated unsuccessfully

From being given to see if there is an undefined components, resulting in the export fails.

Read an article from the MOS, there is a presentation exp / imp version of the classic summary of compatibility issues:

Export client compatibility:

Always use a version of the EXPORT utility that is equal to the lowest version of either the source or the target database.

Export client compatibility: It is recommended to use the source or target database consistent minimum version EXPORT tool version.

Import client compatibility:

Always use a version of the IMPORT utility that is equal to the version of the target database.

Import client compatibility: It is recommended to use the same tools and the target database version IMPORT version.

Here it is clear import and export of our actual needs exp / imp pointed out the direction.
     
         
       
         
  More:      
 
- Linux, Oracle listen address modification (Database)
- Linux installed Cisco Packet Tracer (Linux)
- Use MySQL optimization of security to prevent misuse of aliases (Database)
- Linux Getting Started tutorial: Ubuntu 14.04 in the installation Sogou Pinyin (Linux)
- Oracle 11g new features and associated SQL TUNING (Database)
- Eclipse improve the efficiency of good habits (Programming)
- Linux maximum number of threads and limit the number of queries the current thread (Linux)
- Through the source code to install MySQL 5.6.26 under CentOS6 (Database)
- SteamOS installation under Ubuntu 14.04 (Linux)
- CentOS 6.5 install Maven and Nexus warehouse agent (Server)
- Ubuntu 12.04 install RTL8723BE wireless network card driver (Programming)
- Java implementation heap sort (large root heap) (Programming)
- PCM audio under Linux (Linux)
- IronPython and C # to interact (Programming)
- Unix average load average load calculation method (Server)
- Linux file compression and archiving (Linux)
- MySQL time field based partitioning scheme summary (Database)
- CentOS installed JDK8 (Linux)
- Linux Operating System Security Management describes the top ten tricks (Linux)
- CV: Linux command displays the progress of the run command (Linux)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.