Error 1691 Oracle
Contents |
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
Unable To Extend Lob Segment By 8192 In Tablespace Users
reload this page. Please enter a title. You can not post ora-01691: unable to extend lob segment by 8 in tablespace system a blank message. Please type your message and try again. More discussions in XML DB All PlacesDatabasePerformance
Ora-01691 Impdp
& AvailabilityXML DB This discussion is archived 1 2 Previous Next 15 Replies Latest reply on Jun 24, 2009 4:59 AM by 204585 ORA-01691: unable to extend oracle extend tablespace lob segment RPuttagunta Sep 21, 2006 8:44 PM Hi, I was running an XML transformation using dbms_xmldom package and when I do this for a 1.65 MB sized XML ( the XML is a NON SCHEMA BASED column in a table). I got this error: ORA-1691: unable to extend lobsegment XXXXXXX.SYS_LOB0000073404C00015$$ by 1024 in tablespace XXXXX ora-39171 I would think that I am getting this error because I have built the table by default parameters. Just a create statement. Need some help in tweaking with the parameters while creating the table and the tablespace too. I would be happy to send the parameters I used for this if you say they are relevant here. Please let me know what exactly would you want me to provide. I also have a trace file when I ran that procedure. Thank you, Rahul. 125556Views Tags: none (add) This content has been marked as final. Show 15 replies 1. Re: ORA-01691: unable to extend lob segment Marco Gralike Sep 21, 2006 9:04 PM (in response to RPuttagunta) What database version are you on? Normally this means that the tablespace is full OR that there is not an extent (aka chunk) available that fits the size needed. If so... Check dba_data_files, dba_tablespaces, v$datafile to see how tablespace XXXXX is build up or use: set long 100000 select dbms_metadata
to save the requested page." Oracle
Alter Tablespace Add Datafile
database is being used to back Confluence. The alter tablespace resize following appears in the atlassian-confluence.log: 2011-09-14 11:16:00,690 ERROR [TP-Processor14] [confluence.pages.actions.AbstractEditPageAction] doSaveEditPageBean An
Unable To Extend Table By 128 In Tablespace
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 | https://community.oracle.com/thread/427927 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. https://confluence.atlassian.com/confkb/unable-to-save-page-edits-using-oracle-db-ora-01691-unable-to-extend-lob-segment-278069457.html 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.
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive https://www.experts-exchange.com/questions/26975679/Got-ORA-1691-error-even-when-my-tablespace-was-set-up-with-Autoextend.html Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live http://mohamedbh.blogspot.com/2016/09/r12-error-ora-1691-unable-to-extend.html Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Got ORA-1691 error even when my tablespace was set up with Autoextend Want to unable to Advertise Here? Solved Got ORA-1691 error even when my tablespace was set up with Autoextend Posted on 2011-04-25 Oracle Database 2 Verified Solutions 4 Comments 2,492 Views Last Modified: 2013-12-18 Hello, Yesterday at night I was awaked by a telephone call, informing me that our database reported these errors: ORA-1691: unable to extend lobsegment VAE2011EG.SYS_LOB0000149472C00004$$ by unable to extend 128 in tablespace VAE2011EG_BLOB ORA-1691: unable to extend lobsegment VAE2011EG.SYS_LOB0000149472C00004$$ by 8192 in tablespace VAE2011EG_BLOB VAE2011EG_BLOB is a tablespace for storing blob data. Disk has plenty of space and datafile was set up with Autoextend, as it is shown in attached picture. Additional space to allocate to this datafile as needed is: 10MB. Because it was an emergency I dind't have time to investigate, and just add to the tablaspace a second datafile of 20GB with Autoextend of 20MB. Very similar as first datafile. I suppose that yesterday at night, users wanted to load Blob files larger than 128Kb or 8192Kb, but don't understand why Oracle don't allow them to do that since datafile is setup to grow 10MB if required.Why Oracle was unable to extend lobsegment? This morning I checked alert.log, and as long as I read it, everything was going as I explained. Attached picture shows first and second datafile, but yesterda
attached and save the attachment on oracle forms in R12. ORA-1691: unable to extend lobsegment APPLSYS.SYS_LOB0000033088C00004$$ by 2362205 in tablespace APPLSYSD Solution Check if there enough free space in tablespaces. if so please follow the steps 1. Verify NEXT_EXTENT & MAX_EXTENTS value of the segment highlighted in error SQL> select BYTES,EXTENTS,NEXT_EXTENT,MAX_EXTENTS from dba_segments where segment_name='SYS_LOB0000033088C00004$$'; BYTES EXTENTS NEXT_EXTENT MAX_EXTENTS ---------- ---------- ----------- ----------- 3.8703E+10 33 1.9351E+10 505 NEXT_EXTENT found to be very huge (19 GB) which is the root cause of this issue 2.Reduce segment NEXT_EXTENT size from 19 GB to 1 MB SQL> select owner, table_name, column_name, SEGMENT_NAME from dba_lobs where segment_name='SYS_LOB0000033088C00004$$'; OWNER TABLE_NAME COLUMN_NAME SEGMENT_NAME ----------------------------------------------------------------------------- APPLSYS FND_LOBS FILE_DATA SYS_LOB0000033088C00004$$ SQL> alter table applsys.FND_LOBS modify lob ("FILE_DATA") (STORAGE (NEXT 1048576)); Table altered. SQL> select BYTES,EXTENTS,NEXT_EXTENT,MAX_EXTENTS from dba_segments where segment_name='SYS_LOB0000033088C00004$$'; BYTES EXTENTS NEXT_EXTENT MAX_EXTENTS ---------- ---------- ----------- ----------- 3.8703E+10 33 1048576 505 NEXT_EXTENT is greater than 1 GB & Contiguous free space of the datafile which segment is located may not accommodate next few extents which will lead to allocation of next extent in new datafile. Please verify if other datafiles in the same tablespace has sufficient contiguous space available . If not then add a datafile with size equal to or greater than NEXT_EXTENT else reduce NEXT_EXTENT size Reference : Ora-1691: Unable To Extend Lobsegment Applsys.Sys_lob0000033489c00004$$ By 92170 (Doc ID 378377.1) Poste