ORA-20005: object statistics are locked (stattype = ALL)

Cause

The issue was caused by trying to analyze table for which statistics are locked on source system.

Solution

If locked, ETL analyze step will fail as you are seeing.

To resolve the issue:

1. To get the lock list of tables, you can run the following on the OLTP DB

SQL> select owner, table_name, stattype_locked from dba_tab_statistics where stattype_locked is not null;

2. To unlock, you can use the following SQL on the OLTP DB

SQL> exec dbms_stats.unlock_table_stats([SCHEMA], [TABLE_NAME]);

Example:
exec dbms_stats.unlock_table_stats('APPLSYS','WF_NOTIFICATION_OUT');
exec dbms_stats.unlock_table_stats('ORA29133', 'S_ETL_LOV');

3. Run the following SQL again on the OLTP DB to verify whether any lock remaining.

SQL> select owner, table_name, stattype_locked from dba_tab_statistics where stattype_locked is not null;