Database Utilities (MOSC)

MOSC Banner

IMPDP for transportable tablespaces failed. SHould I re-run with certain specific parameters?

edited Nov 19, 2019 12:07PM in Database Utilities (MOSC) 3 commentsAnswered
Hello,    I was trying ti import (Datapump) a set of tablespaces metadata into a database and it failed with below errors. Since this happened a few days ago, I cannot reattach to the job and re-run it from the point it failed. Now a few tablespaces in the impdp set successfully got the tablespace metadata imported whereas a few didn't. I can see correct # of datafiles associated to all the tablespaces (comparing it with source database), but one particular tablespace has no objects in it, whereas the source database has 10000 table partitions in that particular tablespace.
If I want to restart the whole IMPDP job again just like I did iin n the first run, what will happen when it encounters tablespaces already plugged in and associated with datafiles.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center