I ran an IMPDP from a full export file. I did not have two of the tablespaces setup that the import needed.
If I setup the missing tblsp's can I just rerun the full install without damaging the tables already loaded from my first run?
If not can I can a partial impdp and only import teh two tablespaces I'm missing?
I have read through and I clearly dont know enough about Oracle to figure out what will happen if I try to rerun.
Thank you for any input.
Pl post exact OS and database versions, along with the complete impdp command used and the errors encountered.
It is possible to rerun the import - you will need to set TABLE_EXISTS_ACTION parameter appropriately
Yes, just rerun the impdp command. By default, Data Pump skips objects that already exist. So, since you already imported some tables, when the second import sees those tables, it will try to create them, but when the create fails, it will skip over them. If you ever want import to replace the tables, then use:
by default, this parameter is set to 'SKIP'.
Hope this helps.