10g Datapump import without TABLE_STATISTICS
What are the negatives of using EXCLUDE=TABLE_STATISTICS
While importing a schema into new schema (remapping the schema and tablespace), What possible issues we can run into or what, if any, capabilities/functionality do we loose if we run the impdb with EXCLUDE=TABLE_STATISTICS and EXCLUDE=INDEX_STATISTICS.
Do we always need to have the stats - How can we generate those TABLE_STATISTICS and INDEX_STATISTICS, if we should, after the new schema is created.
dbms_stats would re-create them for you
Click Here to Expand Forum to Full Width