How do I search for all tables of a type in a schema?

[revnice]

Dudes:

Let's assume that you don't have access to DBA_TABLES but you need to find all the tables in a schema that have IMG in thier name.

What would the query need to be?

How can you list all tables in a schema?

Thanks - rev