How to find index organized table

I'm working on Oracle 11g database and I need to list all index-organized tables.
Is there a dba's view to query for that ?

Thanks

Here is the query you require:

SELECT TABLE_NAME 
FROM DBA_TABLES
WHERE IOT_TYPE IS NOT NULL;

The documentation states:


If this is an index-organized table, then IOT_TYPE is IOT,
IOT_OVERFLOW, or IOT_MAPPING. If this is not an index-organized table,
then IOT_TYPE is NULL.

StackExchange Database Administrators Q#51970, answer score: 14