ORACLE视图exu9tne可以删除吗?我在EXP导出时，提示\EXP-00003no storage definition found for segment EXP备份数据库时出现错误提示EXP-00056遇到ORAC...
\u5728Oracle\u5bfc\u51fa\u65f6\uff0c\u51fa\u73b0\u4ee5\u4e0b\u9519\u8bef\u63d0\u793a\u201cEXP-00003: \u672a\u627e\u5230\u6bb5 (6,507) \u7684\u5b58\u50a8\u5b9a\u4e49\u201d\uff0c\u8bf7\u95ee\u662f\u4ec0\u4e48\u613f\u610f\u3002\u670b\u53cb\u770b\u8fc7\u4f60\u7684\u63cf\u8ff0\uff0c\u521d\u6b65\u4f30\u8ba1\u662f\u7531\u4e8e
\u670d\u52a1\u5668oracle\u7248\u672c
client oracle\u7248\u672c
\u4e0d\u4e00\u81f4!
\u4e5f\u6709\u5f88\u591a\u4eba\u9047\u5230\u4f60\u8fd9\u6837\u7684\u9519\u8bef\uff0c\u5730\u5740\u5982\u4e0b\uff1a
http://cache.baidu.com/c?m=9d78d513d9940bed4fece4690d60c067695682613ed6c4523f8a9c12d52219564615fea67d790704a4952f3c57e85e5c9da16b2d2a4b7ae4c6829f4da9b899222e95776a2d499b1a548446b29f1622c2769459e3fe1fb7eda46391a8d3d58b0755c957566d8087d11c5f4a&p=8b2a9544cad552c318bd9b7c5744&user=baidu
http://cache.baidu.com/c?m=9f65cb4a8c8507ed4fece763105392230e54f7387a95974568d4e414c42246444366e5bd2d3510738983233915ea141cbcff6138751421c78cc8fe5ddccb902a2d8a26&p=b47dc816d9c242ff57ee932b4d42bb&user=baidu
\u6700\u597d\u8fd8\u662f\u628a\u5ba2\u6237\u7aef\u4e0e\u670d\u52a1\u5668\u7684\u7248\u672c\u4e00\u6837\u3002
\u89e3\u51b3\u529e\u6cd5\uff1a
\u9009\u62e9\u548c\u8fdc\u7a0b\u670d\u52a1\u5668\u76f8\u540c\u7248\u672c\u5ba2\u6237\u7aef\u91cc\u9762\u7684exp.exe\u3002
\u81f3\u4e8e\u91cc\u9762\u7684\u53c2\u6570buffer size\u7684\u8bdd\uff0c\u7528\u9ed8\u8ba4\u503c\u4e5f\u884c\uff0c\u5047\u5982\u60f3\u5feb\u70b9\u7684\u8bdd\uff0c\u5c31\u8bbe\u7f6e\u5927\u4e00\u70b9\u3002\u4f8b\u5982\u8bbe\u7f6e\u4e3a512000kb\uff0c\u8fd9\u6837\u5047\u5982\u4f60\u672c\u673a\u5185\u5b58\u4e0d\u5927\u7684\u8bdd\uff0c\u53ef\u4ee5\u673a\u5668\u505a\u522b\u7684\u4f1a\u6162\u3002\u4e0d\u8fc7\u5bfc\u51fa\u7684\u901f\u5ea6\u5feb\u3002
\u7528plsql\u5bfc\u51fadmp\u683c\u5f0f\u6570\u636e\u5e93\u65f6\uff0c\u5de6\u4fa7\u201c\u5bf9\u8c61\u201d\u91cc\u9762\u9ed8\u8ba4\u9009\u62e9\u7684\u662f\u201cAll object\u201d,\u8bb0\u5f97\u6539\u4e3a\u201cMy object\u201d\uff0c\u7136\u540e\u5728\u9009\u62e9\u6240\u6709\u7684\u8868\u53f3\u952e\u9009\u62e9\u201c\u5bfc\u51fa\u6570\u636e\u201d\uff0c\u4e4b\u540e\u5f53\u7136\u662f\u9009\u62e9oracle\u5bfc\u51fa\uff0c\u9664\u975e\u4f60\u4e0d\u60f3\u5bfc\u51fadmp\u683c\u5f0f\u6587\u4ef6\u3002\u56e0\u4e3a\u9ed8\u8ba4\u4e3a\u201cAll object\u201d\u65f6\u6709\u5927\u91cf\u7684\u7cfb\u7edf\u8868\uff0c\u8fd9\u4e9b\u8868\u5bfc\u51fa\u6570\u636e\u5e93\u7684\u65f6\u5019\u4f60\u662f\u4e0d\u9700\u8981\u7684\uff0c\u800c\u8fd9\u4e9b\u7cfb\u7edf\u8868\u6570\u636e\u91cf\u5f88\u5927\uff0c\u5bfc\u51fa\u7684\u8bdd\u5f88\u5bb9\u6613\u4f1a\u62a5\u9519\u3002
\u539f\u56e0\uff1a
\u5bfc\u51fa\u7528\u7684\u53ef\u6267\u884c\u6587\u4ef6exp.exe\u4e3a\u672c\u5730\u88c5\u7684oracle\u670d\u52a1\u5668\u7aef\uff0c\u672c\u5730\u7248\u672c\u9ad8\u4e8e\u8fdc\u7a0b\u670d\u52a1\u5668\u7248\u672c\u3002
log\uff1aEXP-00056: \u9047\u5230 ORACLE \u9519\u8bef 6550 \uff0c
ORA-06550: line 1, column 41:
PLS-00302: component 'SET_NO_OUTLINES' must be declared \uff0c
ORA-06550: line 1, column 15:
PL/SQL: Statement ignored \uff0c
EXP-00000: \u5bfc\u51fa\u7ec8\u6b62\u5931\u8d25 \u3002
2. 视图是查询逻辑，简单的说就是一个SQL，是不能导出的
3. 如果要导出视图内的数据，参考这个办法
3.1 create table exu9tne_for_exp as select * from exu9tne;
3.2 exp sys/password file=exu9tne_data.dmp tables=(exu9tneb)
3.3 drop table exu9tne_for_exp --清理导出用的临时表
绛旓細1. 濡傛灉鏄郴缁瑙嗗浘锛屾槸涓嶅厑璁稿垹闄ょ殑 2. 瑙嗗浘鏄煡璇㈤昏緫锛岀畝鍗曠殑璇村氨鏄竴涓猄QL锛屾槸涓嶈兘瀵煎嚭鐨 3. 濡傛灉瑕佸鍑鸿鍥惧唴鐨勬暟鎹紝鍙傝冭繖涓姙娉 3.1 create table exu9tne_for_exp as select * from exu9tne;3.2 exp sys/password file=exu9tne_data.dmp tables=(exu9tneb)3.3 drop table ex...
