On the platform after Oracle 10.2.0.4, we may encounter the following error when importing materialized views using a Data Pump:
...
Ksedmp: internal or fatal error
ORA-7445: exception encountered: core dump [_ intel_fast_memcpy.a () + 10]
[SIGSEGV] [address not mapped to object] [0x000000000] [] []
Current SQL statement for this session:
Alter Materialized View "mview_owner". "mview_name" compile
----- PL/SQL call stack -----
Object line Object
Handle number name
0xbe4518d0 2 anonymous Block
This error is caused by the bug: bug6074902.
Solution:
(1) install patch 6074902
(2) Upgrade the database to 10.2.0.5
Mos document:
DataPump import (impdp) fails with ORA-7445 [_ intel_fast_memcpy.a] while importing materialized views [ID 867578.1]
Bytes -------------------------------------------------------------------------------------------------------
All rights reserved. reprinted articles are allowed, but source addresses must be indicated by links. Otherwise, the documents will be held legally responsible!
Skype: tianlesoftware
QQ: tianlesoftware@gmail.com
Email: tianlesoftware@gmail.com
Blog: http://www.tianlesoftware.com
WEAVER: http://weibo.com/tianlesoftware
Twitter: http://twitter.com/tianlesoftware
Facebook: http://www.facebook.com/tianlesoftware
LinkedIn: http://cn.linkedin.com/in/tianlesoftware
------- Add a group to describe the relationship between Oracle tablespace and data files in the remarks section. Otherwise, reject the application ----
Dba1 group: 62697716 (full); dba2 group: 62697977 (full) dba3 group: 62697850 (full)
Super DBA group: 63306533 (full); dba4 group: 83829929 dba5 group: 142216823
Dba6 group: 158654907 dba7 group: 172855474 DBA group: 104207940