Database Utilities (MOSC)

MOSC Banner

IMPDP with option SKIP_UNUSABLE_INDEXES=YES

edited Jun 1, 2017 5:01AM in Database Utilities (MOSC) 13 commentsAnswered

Hi All,

I am having one query regarding the Unique indexes.

Actually I Have to migrate the data from one database to another. so for that I am using expdp/impdp utility.

Even in impdp to make it faster I am making all the indexes unusable of all the tables which are indulged in migration activity.

After making all the indexes unusable when I has started the import using IMPDP script with option SKIP_UNUSABLE_INDEXES=YES.

its firstly making all the indexes Valid so what the benefit of this approach.

if instead of making these unusable I am droping these indexes import running faster.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center