My Oracle Support Banner

EXPDP TTS - ORA-07445 On TRANSPORTABLE_EXPORT/MATERIALIZED_VIEW_LOG (Doc ID 1567922.1)

Last updated on APRIL 03, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

NOTE: In the images and/or the document content below, the user information and data used represents fictitious data. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

Symptoms

On : 11.2.0.3 version, Data Pump Export

When attempting to run a transport tablespace job in 11.2.0.3 the following errors occur:

expdp "'/ as sysdba'"  DIRECTORY=my_dir DUMPFILE=expdp_tts.dmp LOGFILE=expdp_tts.log FILESIZE=1048576000 TRANSPORT_TABLESPACES=USRS, ...

Export: Release 11.2.0.3.0 - Production on Fri Jul 5 14:41:05 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
...
Processing object type TRANSPORTABLE_EXPORT/POST_TABLE_ACTION
Processing object type TRANSPORTABLE_EXPORT/MATERIALIZED_VIEW_LOG
Job "SYS"."SYS_EXPORT_TRANSPORTABLE_01" stopped due to fatal error at 15:53:47
The Data Pump Worker trace file shows:

...
Exception [type: SIGSEGV, Invalid permissions for mapped object] [ADDR:0x150] [PC:0x9000000348A8050, __as__21TxsOqCountedReferenceXT18TxsOqMdmRootSchema_FP18TxsOqMdmRootSchema()+48] [flags: 0x0, count: 1]

ORA-07445: exception encountered: core dump [__as__21TxsOqCountedReferenceXT18TxsOqMdmRootSchema_FP18TxsOqMdmRootSchema()+48] [SIGSEGV] [ADDR:0x150] [PC:0x9000000348A8050] [Invalid permissions for mapped object] []


The alert logfile shows:

...
Exception [type: SIGSEGV, Invalid permissions for mapped object] [ADDR:0x150] [PC:0x9000000348A8050, __as__21TxsOqCountedReferenceXT18TxsOqMdmRootSchema_FP18TxsOqMdmRootSchema()+48] [flags: 0x0, count: 1]

ORA-07445: exception encountered: core dump [__as__21TxsOqCountedReferenceXT18TxsOqMdmRootSchema_FP18TxsOqMdmRootSchema()+48] [SIGSEGV] [ADDR:0x150] [PC:0x9000000348A8050] [Invalid permissions for mapped object] []

...

The database registry shows valid components:

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.