rac expdp導出時報錯:
ORA-31693: Table data object "scott"."dept" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/home/oraclerac/dump_dir/oravs_expdp_05.dmp" for write
ORA-19505: failed to identify file "/home/oraclerac/dump_dir/oravs_expdp_05.dmp"
ORA-27037: unable to obtain file status
錯誤原因:
在RAC環境下如果PARALLEL參數設置大于1,進程會在RAC的各個節點上進行導出。如果導出目錄不共享的話就會報錯
解決方法:
1、設置為共享的directory;
2、導出語句添加cluster=n選項,指定只在本地導出
免責聲明:本站發布的內容(圖片、視頻和文字)以原創、轉載和分享為主,文章觀點不代表本網站立場,如果涉及侵權請聯系站長郵箱:is@yisu.com進行舉報,并提供相關證據,一經查實,將立刻刪除涉嫌侵權內容。