ORA-30554: function-based index index_name is disabled

SQL>

BEGIN

DBMS_NETWORK_ACL_ADMIN.create_acl (

acl => 'user_sync.xml',

description => 'Purpose of the acl is user synchronization between XE database',

principal => 'USER_SYNC',

is_grant => TRUE,

privilege => 'connect',

start_date => SYSTIMESTAMP,

end_date => NULL);

DBMS_NETWORK_ACL_ADMIN.assign_acl (

acl => 'user_sync.xml',

host => '127.0.0.1',

lower_port => 1,

upper_port => 9999);

COMMIT;

END;

/

*

ERROR at line 1:

ORA-30554: function-based index XDB.XDB$ACL_XIDX is disabled

ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 252

ORA-06512: at line 2

Solution:

SQL>select owner, index_name, status, domidx_status, domidx_opstatus,funcidx_status from dba_indexes where domidx_opstatus is not null;

SQL>alter index XDB.XDB$ACL_XIDX rebuild;

Index altered.

SQL>select owner, index_name, status, domidx_status, domidx_opstatus,funcidx_status from dba_indexes where domidx_opstatus is not null;