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

advertisements

_____________________________________________________________________________________________________________________

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

0 comments:

Post a Comment

Labels

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