After Import sample_size in Dba_tables Shows 2000
Last updated on NOVEMBER 28, 2016
Applies to:Oracle Server - Enterprise Edition - Version: 126.96.36.199 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
Million Knowledge Articles and hundreds of Community platforms