Table Statistics Lock Is Disabled Following Export/Import Using DataPump Or Coventional Export/Import Utility (Doc ID 1245094.1)

Last updated on FEBRUARY 08, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.
***Checked for relevance on 08-FEB-2013***

Symptoms

On the source database, tables which have their statistics locked show a value of 'ALL' when querying the stattype_locked column from user_tab_statistics. However, after export/import to the target database, the statistics are no longer locked as evidenced by a value of NULL when querying the stattype_locked column from user_tab_statistics on the target database.

Changes

Data has just been migrated from a source database to a target database using either the original export/import utility or DataPump.

Cause

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