Oracle Sql Error 8102
Contents |
and SafetyAsset NetworkAsset Operations and
Ora-08102 Index Key Not Found Sap
MaintenanceCommerceOverviewSubscription Billing and Revenue ManagementMaster Data Management oracle rebuild index online for CommerceOmnichannel CommerceFinanceOverviewAccounting and Financial CloseCollaborative Finance OperationsEnterprise Risk and alter index rebuild online ComplianceFinancial Planning and AnalysisTreasury and Financial Risk ManagementHuman ResourcesOverviewCore Human Resources and PayrollHuman Capital AnalyticsTalent ManagementTime and
Ora-00604
Attendance ManagementManufacturingOverviewManufacturing NetworkManufacturing OperationsResponsive ManufacturingMarketingOverviewMarket with Speed and AgilityUnique Customer ExperiencesReal-Time Customer InsightsR&D/EngineeringOverviewDesign NetworkDesign OrchestrationProject and Portfolio ManagementSalesOverviewCollaborative Quote to CashSales Force AutomationSales Performance ManagementSelling Through Contact CentersServiceOverviewEfficient Field Service ManagementOmnichannel Customer ServiceTransparent Service Process
Drop Index Oracle
and OperationsSourcing and ProcurementOverviewContingent Workforce ManagementDirect ProcurementSelf-Service ProcurementServices ProcurementStrategic Sourcing and Supplier ManagementSupply ChainOverviewDemand ManagementDemand NetworkLogistics NetworkManufacturing Planning and SchedulingResponse NetworkResponse and Supply ManagementSales, Inventory, and Operations PlanningTransportation ManagementWarehouse ManagementSustainabilityOverviewEnvironment, Health, and SafetyProduct Safety and Stewardship NetworkBrowse by IndustryAerospace and DefenseAutomotiveBankingChemicalsConsumer ProductsDefense and SecurityEngineering, Construction, and OperationsHealthcareHigh TechHigher Education and ResearchIndustrial Machinery and ComponentsInsuranceLife SciencesMediaMill ProductsMiningOil and GasProfessional ServicesPublic SectorRetailSports and EntertainmentTelecommunicationsTravel and TransportationUtilitiesWholesale DistributionBrowse Platform and TechnologyAnalyticsOverviewBusiness IntelligencePredictive AnalyticsGovernance, Risk, and ComplianceEnterprise Performance ManagementApplication Platform and InfrastructureOverviewApplication PlatformContent and CollaborationInterface ManagementProcess Management and IntegrationData ManagementOverviewBig Data on HadoopData WarehousingDatabase ManagementEnterprise Information ManagementIT ManagementOverviewApplication Lifecycle ManagementIT Infrastructure ManagementSecurity SoftwareOverviewApplication and IT Infrastructure SecurityIdentity,
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About ora-06512 Us Learn more about Stack Overflow the company Business Learn more about hiring
Metalink
developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how https://scn.sap.com/docs/DOC-25939 it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top How do I prevent an ORA-08102 error up vote 0 down vote favorite I am getting an ORA error (08102 - Index Key Not Found) with several customers, and I have been unable to reproduce or explain it. They have all been on the same index http://dba.stackexchange.com/questions/106817/how-do-i-prevent-an-ora-08102-error on the same table. This error is tied to two tables - ALPHA and BRAVO. ALPHA has a primary key on alpha_id. BRAVO links to ALPHA by a foreign key reference to ALPHA.alpha_id. For these customers, all BRAVO rows point to a single APLHA row on the BRAVO table. We have an index on the BRAVO table whose only column is BRAVO.alpha_id. That index, ALPHA_ID_FK, is generating the error when we go to delete rows. As I said, I have been unable to replicate this myself, but I'm getting reports of the same problem by several different customers. We are sometimes able to rebuild the index to correct this issue, but even rebuilding the index is not working for all customers. What is causing this error, and how can I better prevent it? oracle oracle-11g-r2 errors share|improve this question asked Jul 13 '15 at 21:41 rStyskel 1112 Have you contacted Oracle support? The fact that you're getting corrupted index structures often enough to have solutions that work "sometimes" and to be looking to prevent it implies that you have an underlying problem that needs to be diagnosed. You could try dropping and recreating the index rather than
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message https://community.oracle.com/thread/63877 and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 9 Replies Latest reply on May 31, 2011 11:44 PM by 493815 ORA-08102 INDEX KEY NO FOUND, OBJ# 25095, DBA 33567643 (2) 139287 Nov 8, 2002 6:16 PM I'm trying to delete a detail record but it raise this error 'ORA-08102 INDEX KEY NO FOUND, OBJ# 25095, DBA 33567643 (2)' 45800Views Tags: none (add) oracleContent tagged oracle sql with oracle This content has been marked as final. Show 9 replies 1. re:ORA-08102 INDEX KEY NO FOUND, OBJ# 25095, DBA 33567643 (2) 343717 Nov 8, 2002 7:01 PM (in response to 139287) This indicates a possible corrupt index on the table. issue the following command for each index on the table: alter index index_name rebuild; be sure to include the primary key is there is one. Like Show 0 Likes(0) Actions 2. re:ORA-08102 oracle sql error INDEX KEY NO FOUND, OBJ# 25095, DBA 33567643 (2) 139287 Nov 8, 2002 7:27 PM (in response to 343717) I'd try rebuilding all user indexes I'd run the srcipt resulting of select 'ALTER INDEX '||INDEX_NAME||' rebuild tablespace '||tablespace_name||';' from user_indexes; apparently all indexes were rebuilted but the error persist; do you have another idea. Thanks.. Like Show 0 Likes(0) Actions 3. re:ORA-08102 INDEX KEY NO FOUND, OBJ# 25095, DBA 33567643 (2) 343717 Nov 8, 2002 7:56 PM (in response to 343717) Oracle states that it is an internal error and you need to contact Oracle support and provide them with a trace file ... which I am trying to help you avoid. Do a select on all_objects where object_id=25095; If this returns an index or contraint belonging to the affected table then try dropping then recreating the object. If it's not or you can't then you are going to have to raise a TAR. (I suspect there solution would be the same as mine). Good Luck. Like Show 0 Likes(0) Actions 4. Re: re:ORA-08102 INDEX KEY NO FOUND, OBJ# 25095, DBA 33567643 (2) 94799 Oct 4, 2007 11:02 AM (in response to 139287) You don't need to rebuild all indexes, you need to rebuild the index with the given object id. Also standard offline REBUILD may read the exi