Hello,
I have set a table preference to prevent a histogram from being created on a column.
exec dbms_stats.set_table_prefs(user, 'table', 'METHOD_OPT', 'FOR ALL COLUMNS SIZE AUTO, FOR COLUMNS SIZE 1 col_1');
Is there a way/parameter in datapump export to include this preference to import into another schema/database?
It does not seem to come across automatically with exported table statistics.
There is the DBMS_STATS.EXPORT_TABLE_PREFS() procedure to export that to a stats table but I was hoping for something encapsulated with the datapump export/import process.
Database version :12.1.0.2 Standard Edition
Thanks for any insight.
Andrew