【故障處理】imp PLS-00302: component 'SET_NO_OUTLINES' must be declared

secooler發表於2008-10-07

問題現象:

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.0
This problem can occur on any platform.

Symptoms

While trying to export 9.2.0.6 database with 10.2.0.1.0 Exp utility
receive 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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章