|
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时间较长 |
