Skip to content

ORA-39123 ORA-29349 during Transportable Tablespace

Description:

Error occurred while doing import in transportable table space mode because tablespace was already exists from previous import

impdp system@pdbsvc full=y directory=example_dir logfile=transport_example.log network_link=example_dblink transport_datafiles=’+ORADATA1/pdbsvc/A380B9279457244CE0530589020A9EE4/DATAFILE/prod_space.6991.1041528629′

Import: Release 12.2.0.1.0 – Production on Fri May 29 13:22:27 2020

Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 – 64bit Production
Source time zone is -05:00 and target time zone is +00:00.
Estimate in progress using BLOCKS method…
Processing object type DATABASE_EXPORT/PLUGTS_FULL/FULL/PLUGTS_TABLESPACE
Processing object type DATABASE_EXPORT/PLUGTS_FULL/PLUGTS_BLK
ORA-39123: Data Pump transportable tablespace job aborted
ORA-29349: tablespace ‘prod_space’ already exists

Job “SYSTEM”.”SYS_IMPORT_FULL_01″ stopped due to fatal error at Fri May 29 13:24:07 2020 elapsed 0 00:01:33

Solution:

Drop Tablespace with content and datafile

restore and recover tablespace

import again

No comments yet

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: