Unusable Indexes Marked As Usable When TABLE_EXISTS_ACTION=TRUNCATE with Impdp
Last updated on NOVEMBER 28, 2016
Applies to:Oracle Server - Enterprise Edition - Version: 10.2.0.3
Information in this document applies to any platform.
Indexes are unusable prior to import. After a datapump import, the indexes are marked as usable which slows down the import process.
The import is done as follows:
impdp user/password \
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms