【故障處理】imp PLS-00302: component 'SET_NO_OUTLINES' must be declared
問題現象:
IMP-00058: ORACLE error 6550 encountered
ORA-06550: line 1, column 33:
PLS-00302: component 'SET_NO_OUTLINES' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
IMP-00000: Import terminated unsuccessfully
問題原因:使用10.2.0.1版本的exp匯出的檔案,但是目標端使用的是10.1.0.2版本的imp匯入的,所以報錯
問題處理:使用低版本的exp和imp完成資料的遷移。
Subject: | PLS-00302-SET_NO_OUTLINES must be declared When Using 10.2 Export Utility |
Doc ID: | NOTE:339062.1 |
Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.1.0This problem can occur on any platform.
Symptoms
While trying to export 9.2.0.6 database with 10.2.0.1.0 Exp utilityreceive following errors:-
Export: Release 10.2.0.1.0 - Production on Tue Oct 25 17:11:46 2005
Copyright (c) 1982, 2005, 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
Cause
Use of Higher Version Export utility (10.2.0.1) on Lower version database(9.2.0.6).
This problem occurs when using 10.2 Exp utility for 10.1,9.2,8.1.7 databases.
Solution
As per compatibility Matrix,You need to use the export utility of the lower version of source and target database.
-- The End --
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/519536/viewspace-468231/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Rman Backup Fails: PLS-00302: component 'GETREQUIREDSCN' must be declaredAIUI
- 【故障處理】imp-00051,imp-00008
- 【故障處理】一次RAC故障處理過程
- MongoDB故障處理MongoDB
- 故障分析 | Greenplum Segment 故障處理
- GPON網路故障如何處理?GPON網路故障處理流程
- 【故障處理】ORA-600:[13013],[5001]故障處理
- 【故障處理】ORA- 2730*,status 12故障分析與處理
- 【故障處理】因授權資訊丟失導致IMP時出現IMP-00041錯誤的模擬與分析
- linux故障處理Linux
- ora-故障處理
- Error: PLS-00201: identifier 'DBMS_AQ'must be declaredErrorIDE
- 【故障處理】Linux下匯入匯出“IMP-00030: failed to create file ... for write”LinuxAI
- 線上故障處理手冊
- MySQL show processlist故障處理MySql
- 微服務的故障處理微服務
- teams登入故障處理
- Oracle更新Opatch故障處理Oracle
- 如何快速處理線上故障
- Mysql故障處理2則MySql
- dataguard故障處理一則
- AIX系統故障處理AI
- 【Linux】 nfs 故障處理LinuxNFS
- 【故障處理】CRS-1153錯誤處理
- 【故障處理】ORA-19809錯誤處理
- PLS-00201: identifier 'MGMT_TIME_SYNC.STARTUPSYNC' must be declaredIDE
- 如何處理Eclipse錯誤訊息 The declared package does not match the expected packageEclipsePackage
- undo表空間故障處理
- flash_recovery_area故障處理
- 一次dataguard故障處理
- 分散式事務故障處理分散式
- 【故障處理】IMP-00010錯誤 12C的dmp檔案匯入11G
- 【故障處理】ORA-12162 錯誤的處理
- Oracle 10g RAC故障處理Oracle 10g
- 如何處理HTTP 503故障問題?HTTP
- 【故障處理】ORA-01555
- ORA-600 [2662]故障處理
- 處理網路連結故障技巧