DBMS_STATS.GATHER_TABLE_STATS

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

by Ed Chen
June 19, 2021June 3, 2022

ORA-20005 When we tried to gather some statistics on a table which has never been analyzed, we saw ORA-20005 like this: SQL> exec dbms_stats.gather_table_stats(ownname =>… Read More »

How to Move Tables by SQL Script

by Ed Chen
January 16, 2017March 28, 2018

I usually move some tables for data reorganization, and I found the procedure is pretty routine:Moving the table.Rebuilding indexes related to this table.Analyzing all segments… Read More »