Oracle Error 30554
Library mySQL Code Library PHP Code Library JavaScript Code Library Oracle Terms & Definitions Oracle Error Codes PSOUG Community Blogs Oracle Jobs Board PSOUG Forum Oracle User Group Directory Free Oracle Magazines Online Learning Center PSOUG Presentations Advanced Code Search News and Events Sponsors Page Submit Code Contact Us Oracle Error: ORA-30554 Error Description: Function-based index string.string is disabled Error Cause: An attempt was made to access a function-based index that has been marked disabled because the function on which the index depends has been changed. Action: Perform one of the following actions: -- drop the specified index using the DROP INDEX command -- rebuild the specified index using the ALTER INDEX REBUILD command -- enable the specified index using the ALTER INDEX ENABLE command -- make the specified index usable using the ALTER INDEX UNUSABLE command. There haven't been any comments added for this error yet. You may add one if you like. Add a comment Name: Email: URL: Chars left:1000 (1000 max) (No HTML, but newlines will be preserved) Home : Code Library : Sponsors : Privacy : Terms of Use : Contact Us 74 users online © 2009 psoug.org PSOUG LOGIN Username: Password: Forgot your password?
FunctionsPL/SQLORA ERRORBugsScriptsToolsMySQLLinuxOtherContact 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 http://psoug.org/oraerror/ORA-30554.htm => 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 http://www.nazmulhuda.info/ora-30554-function-based-index-index_name-is-disabled line 1:ORA-30554: function-based index XDB.XDB$ACL_XIDX is disabledORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 252ORA-06512: at line 2SQL>select owner, index_name, status, domidx_status, domidx_opstatus,funcidx_status from dba_indexes where domidx_opstatus is not null; OWNER INDEX_NAME STATUS DOMIDX_STATUS DOMIDX_OPSTATUS FUNCIDX_STATUS XDB XDBHI_IDX VALID VALID VALID ENABLED XDB XDB$ACL_XIDX VALID VALID VALID DISABLED 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; OWNER INDEX_NAME STATUS DOMIDX_STATUS DOMIDX_OPSTATUS FUNCIDX_STATUS XDB XDBHI_IDX VALID VALID VALID ENABLED XDB XDB$ACL_XIDX VALID VALID VALID ENABLED Comments Sign in|Recent Site Activity|Report Abuse|Print Page|Powered By Google Sites
Us Press and Media News Room Investor Relations Social Media Directory Latest Videos Solutions Common Challenges Accelerate Product https://support.ptc.com/apps/solution_preview/solution/lang/presolution?lang=en&n=CS50564 Innovation Streamline Compliance and Reduce Risk Increase Customer Value Through Service Increasing Service Revenue Improve Global Product Development Improve Software Quality Internet of Things Increase Service Profitability Enterprise Applications Product Lifecycle Management Computer-Aided Design Application Lifecycle Management Supply Chain Management Service Lifecycle Management By Role Engineering Executive Engineering Manager Sales and oracle error Service Executive Software Executive Supply Chain Executive IT Executive Products Product Families PTC Creo PTC Windchill PTC Arbortext PTC Mathcad PTC Integrity PTC Servigistics ThingWorx All Products Key Topics Working in a Multi-CAD Environment 3D CAD Visualization Retail PLM Manufacturing Process Management Global Product Development Global Product Quality Flexible Modeling Product oracle error 30554 Resources Free Downloads Demos and Tech Tips How to Buy Training PTC Academic Program PTC Creo Customer Stories Free PTC Creo 30 Day Trial PTC Help Centers Services Services Training Services Strategy Services Deployment Services Learning and Adoption Optimization Services Cloud Services Windchill 11 Upgrade Services Communities Networks PTC Community Partners PTC Academic Program Social Media Directory Blogs Product Lifecycle Stories PTC Creo PTC Mathcad Service Leader Events PTC Live Global PTC Live Service Exchange PTC Live Executive Exchange LiveWorx PTC Live Tech Forum Webcasts and Seminars Support Technical Support eSupport Portal Software Downloads PTC Security Updates Report Security Vulnerability Global Support Services Explore Support Solutions Welcome Center Renew Support Re-activate Support Support Advisor eAlert Contact Us Support Resources Customer Support Guide Product Documentation Product Release Calendar Sign up for Technical Alerts Demos and Tech Tips Product Enhancement Requests License Management PTC Help Centers Document Not Found Please try one of th