Why Impdp with remap_table not import table statistics and create index only with the original name?
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?