After Import sample_size in Dba_tables Shows 2000
(Doc ID 438832.1)
Last updated on NOVEMBER 28, 2016
Applies to:Oracle Server - Enterprise Edition - Version: 184.108.40.206 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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!