choti wrote:That's right. It's documented in the SQL language manual
ORA-00934: group function is not allowed here
create index idx_emp on emp(max(install_time))
MAX is an aggregate function.
Restrictions on Function-based Indexes Function-based indexes are subject to the following restrictions: ... The column_expression cannot contain any aggregate functions.