SELECT * FROM ALL_INDEXES WHERE GENERATED ='N' and TABLE_OWNER NOT IN('SYS','SYSJOB','CTISYS');

或者可以这样，默认系统创建的都是“INDEX335*”开头的，同样可以过滤

SELECT * FROM ALL_INDEXES WHERE index_name not like 'INDEX%' and TABLE_OWNER NOT IN('SYS','SYSJOB','CTISYS');