Error From Database System Was Ora-01654
Contents |
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 Us Learn more about Stack Overflow the company Business Learn more about hiring developers ora 01654 unable to extend index by 128 in tablespace or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database
Oracle Ora 01654
Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in ora 00604 ora 01654 the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top ORA-01654: unable to extend index
Ora-01654 Unable To Extend Index By 64 In Tablespace
got the tablespace size increased considerably. But still I am getting this error. I deleted a lot of data thinking that would free-up some space. But that’s of no use. Will shrinking the tablespace or re-sizing the datafiles of the permanent tablespace resolve this issue? Also, the statistics hasn’t been gathered since March. Will gathering the latest statistics help me in any way? oracle share|improve this question asked Jan 11 '12 at 7:43 Savitha migrated from stackoverflow.com Jan 11 '12 at 13:45 This question came from our site for professional and enthusiast programmers. 1 what's the size of the datafile? Is autoextend enabled? –Sathya Jan 11 '12 at 8:46 @Sathya, autoextend can be evil unless you've got a lot of room on the disks. Also, depending on whether the disks are SSDs. If they're not then you want to spread the tablespace datafiles over multiple disks to aid parallelism, which autoextend will not do automatically. –Ben Jan 11 '12 at 8:54 I am also facing similar issue... I too am not a DB person or a DBA... But, would like to understand why this issue is coming up? Can it be because a query is not properly tuned/optimized? Or because we have some dirty code that is inserting more than required data into DB? –user15592 Nov 24 '12 at 8:23 Hello SGD and welcome to DBA.SE. This is not a forum, if you h
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 ora 01654 unable to extend index by 1024 in tablespace users the workings and policies of this site About Us Learn more about ora-01683 unable to extend index Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions
Ora-01654 Unable To Extend Index By 128 In Tablespace Sysaux
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 http://dba.stackexchange.com/questions/10514/ora-01654-unable-to-extend-index-name-of-the-index-by-128-in-tablespace-name others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Oracle - ORA-01654: unable to extend index in tablespace up vote 3 down vote favorite I referred to the below related question, but http://dba.stackexchange.com/questions/107925/oracle-ora-01654-unable-to-extend-index-in-tablespace it was not helpful in my case: ORA-01654: unable to extend index
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have https://community.oracle.com/community/developer/search.jspa?q=ORA-01654 JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it https://scn.sap.com/thread/1788758 enabled. Please turn JavaScript back on and reload this page.Search this communityOracle CommunityBridged communitiesOracle BlogsOracle University TrainingOracle unable to VideosOTN DocumentationOTN Search ResultsSearch forSearch forContentSearch forPeopleSearch forPlacesLast modifiedLast modifiedAll timeLast modified1 dayLast modified7 daysLast modified30 daysLast modified90 daysLast modified1 yearSort byRelevanceRelevanceLast modifiedLast modifiedRestrict results byRestrict results by: PeopleRestrict results by: PlacesSubspace depthSubspace unable to extend depthNo subspacesSubspace depthChild subspacesSubspace depthAll subspacesMatchingMatch names onlyDeactivated UsersShow/HideShowShowAll contentShowBlog postsShowDocumentsShowDiscussionsShowPollsShowIdeasShowStatus updatesShowMessagesShowExternal activityShowShowAll placesShowSpacesShowProjectsShowGroupsContent marked asShowAll ContentShowFinalShowReservedShowCommunity RecommendedShowOutdatedShowAction ItemShowDecisionShowHelpfulShowResolvedShowCommunity Feedback RequestedSocial Search On/OffSearchSearch TipsView more results from Oracle BlogsView more results from Oracle University TrainingView more results from Oracle VideosView more results from OTN DocumentationView more results from OTN Search ResultsAbout Oracle Technology Network (OTN)My Oracle Support Community (MOSC)MOS Support PortalAboutModern Marketing BlogRSS FeedPowered byOracle Technology NetworkOracle Communities DirectoryFAQAbout OracleOracle and SunRSS FeedsSubscribeCareersContact UsSite MapsLegal NoticesTerms of UseYour Privacy Rights© 2007-2016 Jive Software | Powered by Home | Top of pageJive Software Version: 8.0.3.1 , revision: 20160414082626.1619a91.release_8.0.3.x
and SafetyAsset NetworkAsset Operations and MaintenanceCommerceOverviewSubscription Billing and Revenue ManagementMaster Data Management for CommerceOmnichannel CommerceFinanceOverviewAccounting and Financial CloseCollaborative Finance OperationsEnterprise Risk and ComplianceFinancial Planning and AnalysisTreasury and Financial Risk ManagementHuman ResourcesOverviewCore Human Resources and PayrollHuman Capital AnalyticsTalent ManagementTime and 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 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