Database Utilities (MOSC)

MOSC Banner

Why Impdp with remap_table not import table statistics and create index only with the original name?

edited May 5, 2017 5:41AM in Database Utilities (MOSC) 5 commentsAnswered

Oracle Version 12.1.0.2

I want to use impdp with rename_table option to copy table between instances. I want do do this in batch application every night. I have to rename the table because the old one exists from the last night and I want to drop the old table only if the renamed table was successful copied by impdp.

BUT: the renamed table has no statistics and no indexes because the indexes will not be renamed and the indexes exists on the table which created in the night before.

Is this a normal behavior for impdp and rename_table option? Could this that this will change in future: rename also indexes and copy statistics to the renamed table?

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