exp userid=oracle/oracle/@ora10g file=oracle.dmp tables=text_import rows=y indexes=n compress=n buffer=65536 log=oracle.logExport: Release 11.1.0.7.0 - Production on 星期六 2月 27 17:19:30 2010Copyright (c) 1982, 2007, Oracle. All rights reserved.
EXP-00056: 遇到 ORACLE 错误 6550
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: 导出终止失败 各位帮忙解答下!谢谢!
------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群:62697716
服务端是9i
你换用旧版本的exp来导出看看
或者直接在你的服务器上导出你的文件。。
用EXP命令导出数据时,出现
C:\Users\Administrator>exp invoice/qazwsx@wlfp76 file=c:\wlfp76 Export: Release 10.2.0.1.0 - Production on Sun Jan 17 10:48:12 2010 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 在metalink找到原因,需要用旧版本exp来导出数据(服务器Oracle为9i2,客户端我用的是Oracle10g。换到Oracle9i2就没问题了。)
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. 总结一下:高版本的Client 连接 低版本的Server,无法使用exp及imp命令。
昨天我是直接在服务器上导出dmp文件的!
现在知道:高版本的Client 连接 低版本的Server,无法使用exp及imp命令。
以前也遇到过这种情况。