My Oracle Support Banner

How To Import Dependent Objects If The Table Was Pre-Created (Doc ID 1528365.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


Look for a equivalency of impdp parameter IGNORE=Y from imp. i.e.:

- with old imp, when you pre-create the tables and then import into it, you can specify ignore=y to skip ONLY the table creation errors
- imp will bypass the creation error but will insert rows and will create dependent objects like indexes and triggers.
- Trying the same with impdp, it seems the equivalent is to use table_exists_action parameter. But values skip, append or truncate will ignore dependent objects. Replace will drop the existing tables (overpassing the pre-creation). 


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.