please advice :
SQL> create index ABSVIEW_OWNER.VALID_START_ix
2 on ABSVIEW_OWNER.VU_SUBS_PACKAGES(VALID_START);
on ABSVIEW_OWNER.VU_SUBS_PACKAGES(VALID_START)
*
ERROR at line 2:
ORA-01702: a view is not appropriate here
SQL> select OWNER,SYNONYM_NAME,TABLE_OWNER,TABLE_NAME from dba_synonyms where SYNONYM_NAME='VU_SUBS_PACKAGES';
OWNER SYNONYM_NAME TABLE_OWNER TABLE_NAME
------------------------------ ------------------------------ ------------------------------ ------------------------------
PUBLIC VU_SUBS_PACKAGES ABS_VIEW_OWNER VU_SUBS_PACKAGES
ABSVIEW_OWNER VU_SUBS_PACKAGES ABS_VIEW_OWNER VU_SUBS_PACKAGES
SQL>
Thanks