Oracle Error Ora 01691 Unable To Extend Lob Segment
Contents |
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog ora-01691 unable to extend lob segment by 128 in tablespace
ORA-01691 unable ora-1691 unable to extend lob segment in tablespace to extend LOB segment Oracle Database Tips by Burleson Consulting October 16, 2015 Question: I am seeing this ORA-01691 ora-01691: unable to extend lob segment by 8 in tablespace system error and my database is hanging: ORA-01691: unable to extend lob segment WM65NAIP.SYS_LOB0003$$ by 128 in tablespace NAIP65_DATA ORA-01691: unable to extend lob segment WM65NAIP.SYS_LOB003$$ by 1024 in tablespace NAIP65_DATA How doOra-01691 Impdp
I correct the ORA-01691 error? Answer: The oerr utility shows the cause and action for the ORA-01691: ORA-01691: unable to extend lob segment %s.%s by %s in tablespace %s Cause: Failed to allocate an extent of the required number of blocks for LOB segment in the tablespace indicated. Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to ora-39171 the tablespace indicated. In this case of an ORA-01691 error, the solution is to identify the name of the tablespace associated with the LOB segment and add space to the tablespace using the "alter tablespace xxx add datafile yyy size zzz" syntax: alter tablespace NAIP65_DATA add datafile '/u01/app/oracle/ . . . /xxx.dbf size 10G; Note: Sometime the ORA-01691 error is truncated to ORA-1691: ORA-1691: unable to extend lobsegment WM65NAIP.SYS_LOB0003$$ by 128 in tablespace NAIP65_DATA ORA-1691: unable to extend lobsegment WM65NAIP.SYS_LOB003$$ by 1024 in tablespace NAIP65_DATA Oracle Training from Don Burleson The best on site "Oracle training classes" are just a phone call away! You can get personalized Oracle training by Donald Burleson, right at your shop! Burleson is the American Team Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals. Feel free to ask questions on our Oracle forum. Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All leg
VIP Managed PKI Service VIP Access Manager Small Business Endpoint Protection Cloud Ghost Solution Suite Endpoint oracle extend tablespace Encryption SSL/TLS Certificates Code Signing Norton Shopping Guarantee SHOP
Oracle Alter Datafile
ONLINE Website Security SSL Certificates Complete Website Security Code Signing Certificates Norton Shopping Guarantee
Alter Tablespace Add Datafile
Buy SSL Products A-Z Services Services Home Business Critical Services Consulting Services Customer Success Services Cyber Security Services Education Services Solutions Solutions Home http://www.dba-oracle.com/t_ora_01691.htm Intelligent Solutions Intelligent Endpoint Intelligent Cyber Operations Intelligent Data Protection Intelligent Email Intelligent SMB Blue Coat Solutions Topics Encryption Everywhere Internet of Things Office 365 Security Industries Automotive Cyber Insurance Education Financial Services Global Service Providers Industrial Control Systems Healthcare Retail Government Federal Government State https://support.symantec.com/en_US/article.TECH219708.html & Local Support Center Symantec Support Blue Coat Support Symantec Connect Buying Programs Upgrading Products Maintenance & Renewals Training Security Center Security Center Home Updates Virus Definitions & Updates Threats, Risks & Vulnerabilities Security Advisories Publications ISTR Blogs Security White Papers Tools Removal Tools Spyware Removal English 中文(简体) 中文(繁體) Česká English Français Deutsch Magyar Italiano 日本語 한국어 Polski Português Pусский Español Partner Find a Partner Enroll in a Partner Program Partner Programs Product Resources for Partners Blue Coat Partners Login Required Partner Resources Products A-Z Financial Benefits Partner Licensing Partner Renewals Partner Training United States / English Search Technical Support Support MySymantec Licensing Products A-Z Login Profile Subscriptions Logout Login Forgot Password? Don't have a SymAccount? Create a SymAccount now!' ORA-01691: unable to extend lob segment TECH219708 January 27th, 2014 http://www.symantec.com/docs/TECH219708 Support / ORA-01691: un
to save the requested page." Oracle https://confluence.atlassian.com/confkb/unable-to-save-page-edits-using-oracle-db-ora-01691-unable-to-extend-lob-segment-278069457.html database is being used to back Confluence. The following appears in the atlassian-confluence.log: 2011-09-14 11:16:00,690 ERROR [TP-Processor14] [confluence.pages.actions.AbstractEditPageAction] doSaveEditPageBean An error occured while storing the requested page! -- url: /confluence/pages/doeditpage.action | page: 285933767 | userName: username | referer: http://example.com/confluence/pages/editpage.action?pageId=285933767 | unable to action: doeditpage org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not insert: [com.atlassian.confluence.core.BodyContent#302481465]; uncategorized SQLException for SQL []; SQL state [72000]; error code [1691]; ORA-01691: unable to extend lob segment WIKI.SYS_LOB0000013266C00002$$ by 8192 in tablespace WIKI Cause The Oracle database has run out of space. unable to extend The database has failedto allocate an extent of the required number of blocks for LOB segment in the tablespace indicated. Resolution Your database administrator will need to add or extend a datafile to the tablespace relevant to Confluence. Was this helpful? Yes No Thanks for your feedback! Why was this unhelpful? It wasn't accurate It wasn't clear It wasn't relevant Submit feedback Cancel Have a question about this article? See questions about this article Powered by Confluence and Scroll Viewport Atlassian Support Ask the community Provide product feedback Contact technical support Atlassian Privacy Policy Terms of use Security Copyright © 2016 Atlassian Except where otherwise noted, content in this space is licensed under a Creative Commons Attribution 2.5 Australia License.