Fully remove join on DBA_SEGMENTS to retrieve the list of tables, views and comments. Replaced by ALL_OBJECTS. Thanks to Dominique Legendre for the help.