Rerun Data Pump Import Transportable Database

From: Seth Miller <sethmiller.sm_at_gmail.com>
Date: Mon, 21 Dec 2015 11:46:11 -0600
Message-ID: <CAEueRAVngaEX5q5jM67RzcBfR9_jr2UNLmf3mx=JXYuthK_U_Q_at_mail.gmail.com>

Source:

• 11.2.0.4
• Suse 11.3

Target:

• 12.1.0.2 PDB
• Oracle Linux 6.6 (Exadata)

I'm trying to run a transportable database data pump import. The first run was successful for the tablespaces but user creation failed and a number of other errors occurred because there were temporary tablespaces on the source that had not been created on the target. I was able to create the temporary tablespaces after the import was complete but now when I try to run the data pump import again, I get an error that the tablespace already exists.

impdp full=Y dumpfile=dump.dmp directory=data_pump_dir logfile=import.log transport_datafiles=datafile1.dbf, datafile2.dbf, etc.

Processing object type DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/PLUGTS_FULL/PLUGTS_BLK

ORA-39123: Data Pump transportable tablespace job aborted ORA-29349: tablespace 'TBS1' already exists

If I try running it as a regular import, it fails as well.

impdp full=Y dumpfile=dump.dmp directory=data_pump_dir logfile=import.log ORA-39002: invalid operation
ORA-39243: Import job requires 'TRANSPORT_DATAFILES' parameter.

Is there a way to bypass the TTS part of the import so I can get the rest of the data without generating a new data pump export?

Seth Miller

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Dec 21 2015 - 18:46:11 CET