Oracle Error Unable To Extend Lob Segment
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 reload this page. Please enter a title. You can not post a blank message. Please type
Ora-01691 Unable To Extend Lob Segment By 128 In Tablespace
your message and try again. More discussions in XML DB All PlacesDatabasePerformance & AvailabilityXML ora-1691 unable to extend lob segment in tablespace DB This discussion is archived 1 2 Previous Next 15 Replies Latest reply on Jun 24, 2009 4:59 AM by 204585 ORA-01691: ora-01691: unable to extend lob segment by 8 in tablespace system unable to extend 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
Ora-01691 Impdp
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 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
Ora-39171
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. 126822Views 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.get_ddl('TABLESPACE','XXXXX') from dual; or you could, alter database datafile '?????.dbf' resize {bigger size}; or you could, alter database datafile '????.dbf' autoextend on next 10M maxsize 2048MYou could try to free up space via a coalesce tablespace statement of free space a different way. You can check in dba_free_space if there is still a chunck of space free (probably none or < 1024 in size) Like Show 0 Likes(0) Actions 2. Re: ORA-01691: unable to extend lob segment RPuttagunta Sep 21, 2006 9:12 PM (in response to Marco Gralike) Marco, Version 10.2.0.1.0. Ok, I have run this. SQL> select dbms_metadata.get_ddl('TABLESPACE','XXXXX
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 oracle extend tablespace Us Learn more about Stack Overflow the company Business Learn more about hiring
Alter Tablespace Add Datafile
developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the unable to extend table by 128 in tablespace Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up ORA-01691: unable to extend lob https://community.oracle.com/thread/427927 segment XXXXXXXX by 8192 in tablespace USERS up vote 0 down vote favorite I get the below error when I try to insert data in the database. ORA-01691: unable to extend lob segment XXXXXX by 8192 in tablespace USERS I'm using an Oracle database (express 12c version). Googling the error I found that it means that there no more space in the tablespace and you need http://stackoverflow.com/questions/31311964/ora-01691-unable-to-extend-lob-segment-xxxxxxxx-by-8192-in-tablespace-users to increase the dimension of your datafile or the number of datafile you are using. I have 5 datafile of 30 GB and one of them is empty so I don't understand what the problem is. Edit SYSTEM 793,19 800 99,15 32768 2,42 SYSAUX 2203,56 2320 94,98 32768 6,72 UNDOTBS1 48,13 23345 0,21 32768 0,15 USERS 153534,5 30720 499,79 30720 499,79 USERS 153534,5 30720 499,79 30720 499,79 USERS 153534,5 30720 499,79 30720 499,79 USERS 153534,5 30720 499,79 30720 499,79 USERS 153534,5 30720 499,79 30720 499,79 database oracle oracle12c share|improve this question edited Jul 9 '15 at 8:51 Ameya Deshpande 2,35121026 asked Jul 9 '15 at 8:22 JJJ 5019 add a comment| 2 Answers 2 active oldest votes up vote 1 down vote paste the results of the following select d.tablespace_name "TS", (select round(sum(s.bytes/(1024*1024)),2) from dba_segments s where (s.tablespace_name = d.tablespace_name) group by s.tablespace_name) "Used", round(d.bytes/(1024*1024)) "FSize", round((select sum(s.bytes/(1024*1024)) from dba_segments s where s.tablespace_name = d.tablespace_name group by s.tablespace_name)*100/(d.bytes/(1024*1024)),2) "% Used", round(maxbytes/(1024*1024)) "MAX FSize", round((select sum(s.bytes/(1024*1024)) from dba_segments s where (s.tablespace_name = d.tablespace_name) AND (d.AUTOEXTENSIBLE = 'YES') group by s.tablespace_name)*100/(maxbytes/(1024*1024)),2) "% Used of MAX" from dba_data_files d; share|improve this answer answered Jul 9 '15 at 8:27
Topic Error messages Database Admin View All Cloud infrastructure Availability Backup and recovery Database design Export, import and migration Installation, upgrades and patches Oracle performance problems and tuning Oracle security Oracle DBA tools MySQL http://searchoracle.techtarget.com/answer/What-s-causing-unable-to-extend-lob-segment-error database Real Application Clusters (RAC) Applications View All Enterprise and business performance management Implementing and upgrading Oracle apps E-Business Suite Fusion applications Hyperion JD Edwards (JDE) PeopleSoft Siebel and Oracle CRM Data Mgmt View All BI (business intelligence) Data quality Data warehousing Metadata Database Admin View All Cloud infrastructure Availability Backup and recovery Database unable to design Export, import and migration Installation, upgrades and patches Oracle performance problems and tuning Oracle security Oracle DBA tools Error messages MySQL database Real Application Clusters (RAC) Development View All BPEL in Oracle Open Source SQL Java / J2EE Stored procedures XML PL/SQL Fusion View All Oracle and BEA Application Server Data and application integration unable to extend SOA (service-oriented architecture) Infrastructure View All Cloud computing infrastructure Exadata and Exalogic Grid computing Oracle on Linux Operating system Oracle hardware decisions Virtual machine Oracle management View All certification Oracle acquisitions Business process management Market analysis DBA jobs training and certification Small businesses Regulatory compliance Outsourcing Oracle on demand and SaaS Oracle strategy and product roadmap Oracle support services Oracle vs. SAP Oracle Web 2.0 Sun-Oracle infrastructure View All Oracle cloud computing Oracle OS Oracle virtualization Topics Archive View All Oracle DBA jobs Oracle Resources Training and certification Tutorials, tips and FAQs Please select a category Applications Data Mgmt Database Admin Development Fusion Infrastructure Oracle management Sun-Oracle infrastructure Section Problem Solve News Get Started Evaluate Manage Problem Solve Sponsored Communities Q What's causing unable to extend lob segment error? Sections Share this item with your network: Related Expert Q&A Moving table with indexes to another tablespace – SearchOracle Moving a table with a LOB column – SearchOracle LOB tables missing with exp/imp mo