_____________________________________________________________________________________________________________________
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