Expdp failed with ORA-39047 ORA-39047: Jobs of type TRANSPORTABLE cannot use multiple execution streams


The Eucharistic Miracles of the World
Error Description: 

Data Pump export (expdp) with transport_tablespace failed with following error.

date;expdp dumpfile=TTS.dmp%u logfile=TTS.log directory=TTS transport_tablespaces=USERS PARALLEL 16;date
Fri Jul 21 05:00:39 CUT 2017

Export: Release - Production on Fri Jul 21 05:00:39 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Username: / as sysdba

Connected to: Oracle Database 11g Enterprise Edition Release - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39047: Jobs of type TRANSPORTABLE cannot use multiple execution streams.
Solution Description

You cannot use the parallel option with transportable_tablespace option in expdp. You should remove the parallel option. Below is the correct syntax.

expdp dumpfile=TTS.dmp logfile=TTS.log directory=TTS transport_tablespaces=USERS


Website Stats


Post a Comment


Oracle (580) General (60) Unix (47) Script (41) Blog (23) OCI (3) SQL* Loader (3) Datapump (2) Software (1)
DBA Tips

acehints.com Copyright 2011-21 All Rights Reserved | Site Map | Contact | Disclaimer