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

advertisements

_____________________________________________________________________________________________________________________

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 11.2.0.4.0 - 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 11.2.0.4.0 - 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.

advertisements

 

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