Unusable Indexes Marked As Usable When TABLE_EXISTS_ACTION=TRUNCATE with Impdp (Doc ID 555909.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.3 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.

Symptoms

-- Problem Statement:
Indexes are unusable prior to import.  After a datapump import, the indexes are marked as usable which slows down the import process.

Changes

The import is done as follows:
impdp user/password \
TABLE_EXISTS_ACTION=TRUNCATE \
CONTENT=DATA_ONLY \
REMAP_SCHEMA=OLD_SCHEMA:NEW_SCHEMA \
TABLES=TEST_TABLE \
DUMPFILE=dump.dmp \
LOGFILE=log.log \
DIRECTORY=DUMPDIR \
JOB_NAME=IMPORT_JOB

Cause

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