Table Statistics Lock Is Disabled Following Export/Import Using DataPump Or Coventional Export/Import Utility
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***
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.
Data has just been migrated from a source database to a target database using either the original export/import utility or DataPump.
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