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