Oracle Error 01631
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-01631 Error Description: Max # extents (string) reached in table string.string Error Cause: A table tried to extend past maxextents. Action: If maxextents is less than the system maximum, raise it. Otherwise, you must recreate with larger initial, next or pctincrease params. 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 68 users online © 2009 psoug.org PSOUG LOGIN Username: Password: Forgot your password?
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 http://psoug.org/oraerror/ORA-01631.htm 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 https://scn.sap.com/thread/1471985 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 ManagementIT ManagementOverviewApplication Lifecycle ManagementIT Infrastructure ManagementSecurity SoftwareOverviewApplicatio
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have https://community.oracle.com/community/developer/search.jspa?q=ORA-01631 JavaScript enabled. This tool uses JavaScript http://harvarinder.blogspot.com/2012/06/ora-01631-max-extents-121-reached-in.html and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page.Search this communityOracle CommunityBridged communitiesOracle BlogsOracle University TrainingOracle oracle error 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 oracle error 01631 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
max # extents (121) reached in table HARVEY.MLOG$_MV_HARVEY ORA-02063: preceding 2 lines from DB_LINK_DATA I was getting the error message when trying to insert a record using database link ofDB_LINK_DATA. This issue was resolved by updating the max_extents to unlimited on the target database (underDB_LINK_DATA). This was done by running the following command on the database underDB_LINK_DATA SQL> select OWNER, TABLE_NAME, TABLESPACE_NAME, PCT_FREE,PCT_USED,STATUS, MIN_EXTENTS, MAX_EXTENTS,NEXT_EXTENT from dba_tables where table_name ='MLOG$_ALL_OBJECT_ROLES'; OWNER TABLE_NAME TABLE PCT_FREE PCT_USED STATUS MIN_EXTENTS MAX_EXTENTS NEXT_EXTENT ---------- ------------------------------ ----- ---------- ---------- -------- ----------- ----------- ----------- HARVEY MLOG$_MV_HARVEY HARVEY 60 30 VALID 1 121 131072 alter table HARVEY.MLOG$_MV_HARVEY storage(maxextents unlimited); SQL> select OWNER, TABLE_NAME, TABLESPACE_NAME, PCT_FREE,PCT_USED,STATUS, MIN_EXTENTS, MAX_EXTENTS,NEXT_EXTENT from dba_tables where table_name ='MLOG$_ALL_OBJECT_ROLES'; OWNER TABLE_NAME TABLE PCT_FREE PCT_USED STATUS MIN_EXTENTS MAX_EXTENTS NEXT_EXTENT ---------- ------------------------------ ----- ---------- ---------- -------- ----------- ----------- ----------- HARVEY MLOG$_MV_HARVEY HARVEY 60 30 VALID 1 2147483645 131072 Posted by Harvey Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest Reactions: No comments: Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Android App App development is my hobby and I have created an app to keep track of personal fever, medicine and any notes. This android app can be downloaded by clicking the link below: https://play.google.com/store/apps/details?id=com.appowl247.fever Visitor Number Blog Archive ► 2016 (44) ► October (11) ► September (6) ► August (1) ► June (4) ► May (2) ► April (11) ► February (4) ► January (5) ► 2015 (11) ► August (1) ► January (10) ► 2014 (35) ► December (6) ► June (6) ► May (1) ► April (4) ► March (6) ► February (12) ► 2013 (12) ► August (2) ► July (1) ► June (1) ► April (2) ► March (1) ► February (4) ► January (1) ▼