Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Will the indexes be ignored when using IMPDP...TABLE_EXISTS_ACTION=SKIP?

MorvenJun 18 2011 — edited Jun 18 2011
Hi guys,

11gr2
suppose that i have a .dmp file which has tables, indexes, and data,
and i also have a schema A which already contains tables and data, without indexes
is it possible to use IMPDP to import(or say create) all indexes from .dmp to schema A?

the relevant question is, when using IMPDP...TABLE_EXISTS_ACTION=SKIP, if the table already exists, will IMPDP ignores the relevant indexes creation?


thank you!!!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 16 2011
Added on Jun 18 2011
#general-database-discussions
2 comments
544 views