Re: Rerun Data Pump Import Transportable Database

This is not standard TTS, this is the 12c feature (backported to 11.2.0.3/4) Full Transportable Export/Import.

I was unable to resolve the issue. MOS's solution was to drop the tablespaces from the target database, re-copy all of the data files from the source to target and execute the import again.

I ended up going back to a standard TTS with all of the manual steps required. At least this way I can separate all of the metadata from the TTS and execute the import multiple times.

Seth Miller

On Mon, Dec 21, 2015 at 11:59 AM, Jeremy Schneider < jeremy.schneider_at_ardentperf.com> wrote:

> interesting - in 11.2.0.3 user objects weren't included in TTS exports
> as far as i knew (and according to comparisons of
> SCHEMA_EXPORT_OBJECTS and TRANSPORTABLE_EXPORT_OBJECTS views).
>
> couldn't tell from your email - were you already using the
> include/exclude params to impdp to isolate just the user objects? (i
> would imagine so.)
> --
> http://about.me/jeremy_schneider
>
>
> On Mon, Dec 21, 2015 at 12:46 PM, Seth Miller <sethmiller.sm_at_gmail.com>
> wrote:
> > 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