FAIL => Table AUD$[FGA_LOG$] should use Automatic Segment Space Management
Hi,
When we run exachk (database version 19.14 on Exadata X8M-2 | x86_64 Linux VM), we get the message " FAIL => Table AUD$[FGA_LOG$] should use Automatic Segment Space Management for xxx"
However, we've found it's auto with details query below:
SQL> col TABLE_NAME format a10
col segment_space_management format a20
col tablespace_name format a10
select t.table_name,ts.segment_space_management, ts.tablespace_name from dba_tables t, dba_tablespaces ts where ts.tablespace_name = t.tablespace_name and t.table_name in ('AUD$','FGA_LOG$');
TABLE_NAME SEGMENT_SPACE_MANAGE TABLESPACE
---------- -------------------- ----------