After Import sample_size in Dba_tables Shows 2000
Last updated on NOVEMBER 28, 2016
Applies to:Oracle Server - Enterprise Edition - Version: 18.104.22.168 to 10.2.0.3
This problem can occur on any platform.
When the table in question is exported and imported either in the same or different database and checked for the sample_size in dba_tables it shows 2000 regardless of the value before the export.
The parameter STATISTICS set to COMPUTE during export and RECALCULATE_STATISTICS=N during import.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms