You are performing a database export against your database The database export abnormally ends with the following errors: EXP: ORACLE error encountered ORA: invalid input value EMIT_SCHEMA for parameter NAME in function SET_TRANSFORM_PARAM ORA: at SYSDBMS_SYS_ERROR line ORA: at SYSDBMS_METADATA_INT line ORA: at SYSDBMS_METADATA_INT line ORA: at SYSDBMS_METADATA line ORA: at line EXP: Export terminated unccessfully
這個問題困擾我好幾天原本好好的export在上了Oracle的patchset後竟然無法進行fully export查了很久只知道是個bug最後終於知道解決辦法分享給各位
) 如果在安裝patchset之前就已經有資料庫存在則安裝好patch後必須補做下面程序
sqlplus /nolog
SQL>connect sys as sysdba Connected
SQL>shutdown normal; after database is shutdown
SQL>startup migrate [pfile=] use the pfile if using one skip if using spfile
SQL>spool c:catpatchlog
SQL>@c:oracleora dbmsadmincatpatchsql
SQL>spool off
SQL>shutdown normal; after database is shutdown
SQL>startup restrict [pfile=] use the pfile if using one skip if using spfile
SQL>@c:oracleora dbmsadminutlrpsql
SQL>alter system disable restricted session;
執行過catpatchsql後你的資料庫就可以繼續正常使用fully export了(此script會執行很久)
) 若是安裝patch後才利用DBCA建立新資料庫若在DBCA GUI下你選擇OLTP OR OLAP等資料庫模式來建立則資料庫建好仍然必須補做catpatchsql若你是選擇customer方式來建立資料庫他會幫你執行相關程序也就是說你不需要在補做catpatchsql了不過這種方式的建立DB時間較長
From:http://tw.wingwit.com/Article/program/Oracle/201311/16997.html
