ORAchk 12.1.0.2.7 reports that "LOB PARTITION" is Duplicate objects
hello,
ORAchk 12.1.0.2.7 reports that "LOB PARTITION" is Duplicate objects in report file.
------------------------------------
Duplicate sys/system objects
...
Status on RE31C:
WARNING => Duplicate objects were found in the SYS and SYSTEM schemas
DATA FOR RE31C FOR DUPLICATE SYS/SYSTEM OBJECTS
SYS_LOB0000012930C00016$$.LOB PARTITION = 8 <<<<<<<<<<<<<<< HERE
SYS_LOB0000006450C00009$$.LOB PARTITION = 25 <<<<<<<<<<<<<<< HERE
------------------------------------
I checked the sql script which got above result.
The sql is like:
select object_name||'.'||object_type||' = '||count(*) from dba_objects
where owner in ('SYS','SYSTEM')
and object_type not in ('TABLE PARTITION','TABLE SUBPARTITION','INDEX PARTITION','INDEX SUBPARTITION','LOB_PARTITION') <<<<<<< LOB_PARTITION