Shrink FND_LOG_MESSAGES table size for gain more space

Description:

Shrink FND_LOG_MESSAGES table size for gain more free space.

Steps:

select owner, segment_name, bytes/1024/1024/1024 gb
from dba_segments where segment_type = ‘TABLE’
and segment_name = ‘FND_LOG_MESSAGES’;

SQL> alter table applsys.fnd_log_messages enable row movement;

SQL> alter table applsys.fnd_log_messages shrink space;