Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ exp / imp Export Import version of the problem and the ORA-6550 error     - To_explore Linux system boot process (Linux)

- MyCAT log analysis (Database)

- Under CentOS 7 installation and deployment environment Ceph (Server)

- Linux raw socket (Programming)

- Git Getting Started tutorial (Linux)

- The first deployment of cross-platform operation Rafy record (Server)

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

- Disk partition MBR (Linux)

- The practical application of Oracle synonyms + dblink (Database)

- Upgrading Oracle 11.2.0.1.0 to 11.2.0.3.0 (Database)

- Graphical development environment to build Android under Ubuntu 11.04 (Linux)

- Docker commonly used commands Description (Linux)

- How x2go set up Remote Desktop on Linux (Linux)

- Getting the Linux shell expr use (Programming)

- Android View event delivery (Programming)

- RHEL (RedHat) 6.3 using EPEL Yum source (Linux)

- Oracle 11g dataguard main library backup and recovery to the test environment in one database error (Database)

- Formatted output printf command (Programming)

- Laravel 4.2 Laravel5 comprehensive upgrade Raiders (Server)

- Linux LVM Logical Volume Management to resize partitions (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:      
 
- PHP Performance Analysis and Experiment: Performance Micro Analysis (Programming)
- Android will save the picture to see the album and timely (Programming)
- Tsunami-udp accelerated network transmission (Linux)
- Under CentOS yum install Nginx smooth switch mounted to Tengine (Server)
- 24 Docker recommendations (Linux)
- MacBook Air install Ubuntu dual system (Linux)
- GRUB and Linux system repair (Linux)
- How to use Aptik to backup and restore Apps/PPAs under ubuntu (Linux)
- BusyBox build root file system (Linux)
- Linux reserves the rest of the file to delete several (Linux)
- About Hibernate cache, you want the latest data have trouble even session.clear (Database)
- Linux Security (Linux)
- CentOS Linux Optimization and real production environment (Linux)
- Teach you how to protect the Linux operating system security tips (Linux)
- When RHEL7 use fdisk partition, all partitions can not be used (Linux)
- Category prevent DoS attacks against Linux (Linux)
- Plasma 5.4 How to install on Kubuntu 15.04 (Linux)
- Linux automatic installation and implementation (Linux)
- Upload the project to GitHub, synchronous remote repository Github (Linux)
- Local port forwarding using iptables under linux (Server)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.