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 (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2)

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