problem with Database tuning query pag 314

[David chamorro]

HI, i found an error in the sql page 314

SELECT DISTINCT my_tables.owner, 

                            my_tables.table_name, 

                            my_tables.tablespace:name  tablespace_name

FROM my_tables, my_indexes 

WHERE my_tables.owner = my_indexes.table_owner 

AND my_tables.table_name = my_indexes.table_name 

AND my_indexes.index_type = :index_ type  column  doesn't exist in my_tables

with corrections 

SELECT DISTINCT my_tables.owner, 

                            my_tables.table_name, 

                             my_tables.tablespace_name

FROM my_tables, my_indexes 

WHERE my_tables.owner = my_indexes.table_owner 

AND my_tables.table_name = my_indexes.table_name