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

_____________________________________________________________________________________________________________________

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.

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

_____________________________________________________________________________________________________________________

0 comments:

Post a Comment

 

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