The ANALYZE clause requires use of a user temporary table space. If the ANALYZE clause is needed, then you must have the USE privilege for the table space in order to use the index advisor.