當Oracle數據庫中使用不同版本的exp工具進行數據庫導出時有時候會遇到類似如下錯誤
EXP: no storage definition found for segment( )
EXP: no storage definition found for segment( )
EXP: no storage definition found for segment( )
EXP: no storage definition found for segment( )
EXP no storage definition found for segment ……錯誤和Oracle的一個小Bug相關可以通過修改一個導出相關的View來解決
在目標數據庫使用sys用戶執行如下SQL創建新的view
CREATE OR REPLACE VIEW exutne (
tsno fileno blockno length) AS
SELECT ts# segfile# segblock# length
FROM sysuet$
WHERE ext# =
UNION ALL
SELECT * FROM SYSEXUTNEB
/
然後就可以正常進行導出操作exp完成後 最好將視圖還原（Metalink建議）
CREATE OR REPLACE VIEW exutne (
tsno fileno blockno length) AS
SELECT ts# segfile# segblock# length
FROM sysuet$
WHERE ext# =
/
EXUTNE視圖初始由 $ORACLE_HOME/rdbms/admin/catexpsql 腳本創建
From:http://tw.wingwit.com/Article/program/Oracle/201311/17770.html
