Ora 1691 Error
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 ora-01691 unable to extend lob segment by 8192 in tablespace Excel-DB Don Burleson Blog
Ora-01691: Unable To Extend Lob Segment By 8 In Tablespace System
ORA-01691 unable to extend LOB segment Oracle Database Tips by Burleson Consulting October ora-01691 impdp 16, 2015 Question: I am seeing this ORA-01691 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
Ora-01692 Unable To Extend Lob Segment
extend lob segment WM65NAIP.SYS_LOB003$$ by 1024 in tablespace NAIP65_DATA How do 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 ora-39171 indicated. Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to 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 que
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss
Oracle Increase Tablespace Size
the workings and policies of this site About Us Learn more
Alter Tablespace Add Datafile
about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow alter tablespace resize Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping http://www.dba-oracle.com/t_ora_01691.htm each other. Join them; it only takes a minute: Sign up ORA-1691: unable to extend lobsegment up vote 1 down vote favorite I'm getting this error: ORA-1691: unable to extend lobsegment ABC.SYS_LOB0014859757C00018$$ by 1280 in tablespace ABC The tablespace is build like the folowing: CREATE TABLESPACE "ABC" DATAFILE '/ora/db/user/abc1.db' SIZE 4194304000, '/ora/db/user/abc2.db' SIZE 4194304000, '/ora/db/user/abc3.db' SIZE 4194304000, '/ora/db/user/abc4.db' http://stackoverflow.com/questions/30057556/ora-1691-unable-to-extend-lobsegment SIZE 4194304000 LOGGING ONLINE PERMANENT BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10485760 SEGMENT SPACE MANAGEMENT AUTO How can I extend the tablespace? Do I need to restart db after extending? database oracle oracle11g oracle10g ddl share|improve this question edited May 5 '15 at 15:56 Mureinik 103k2054104 asked May 5 '15 at 15:45 user897237 3031517 add a comment| 1 Answer 1 active oldest votes up vote 2 down vote accepted You can extend a tablespace by adding an additional datafile to it or by extending an existing one. Since you currently seem to have a convention of uniformly sized files, I'd just add another one: ALTER TABLESPACE "ABC" ADD DATAFILE '/ora/db/user/abc5.db' SIZE 4194304000; This can be done with the database and tablespace online, and there's no need to restart anything. share|improve this answer answered May 5 '15 at 15:51 Mureinik 103k2054104 Thank you. The size is in bytes? –user897237 May 5 '15 at 15:55 1 @user897237 yes. Although if you wish, you could also specify the size in K,
2013 ORA-1691: unable to extend http://www.moreajays.com/2013/09/ora-1691-unable-to-extend-lobsegment.html lobsegment APPLSYS.SYS_LOB in tablespace APPLSYSD Error: ORA-1691: unable to extend lobsegment APPLSYS.SYS_LOB0000255030C00040$$ by 1574805 in tablespace APPLSYSD Analysis & Solution: Step1: Verify Free space in tablespace & Check data file size SQL> unable to select dt.tablespace_name,round(sum(df.bytes)/1024/1024/1024,0) "Free_GB" from dba_free_space df,dba_tablespaces dt where df.tablespace_name=dt.tablespace_name(+) and df.tablespace_name not in (select tablespace_name from dba_temp_files) group by dt.tablespace_name order by 1;TABLESPACE_NAME Free_GB------------------------------ ----------APD 0APPLSYSD 114APPLSYSX 139APPS_UNDOTBS01 0APPS_UNDOTBS02 6. . ASFD unable to extend 0 SQL> select file_name,bytes/1024/1024 from dba_data_files where tablespace_name='APPLSYSD'; FILE_NAME BYTES/1024/1024------------------------------------------------------------ ---------------/data01/oracle/crmprdata/applsysd01.dbf 9216/data01/oracle/crmprdata/applsysd02.dbf 8192/data02/oracle/crmprdata/applsysd03.dbf 8192/data02/oracle/crmprdata/applsysd04.dbf 9216/data04/oracle/crmprdata/applsysd05.dbf 9692/data04/oracle/crmprdata/applsysd06.dbf 9216/data02/oracle/crmprdata/applsysd07.dbf 8196/data01/oracle/crmprdata/applsysd08.dbf 8696/data01/oracle/crmprdata/applsysd13.dbf 4000/data04/oracle/crmprdata/applsysd09.dbf 8192. . . 27 rows selected. Free space in tablespace found to be over 100 GB , So it is not space issue but some storage parameter issue Step 2: If enough free space is available then verify NEXT_EXTENT & MAX_EXTENTS value of the segment highlighted in error SQL> select * from dba_segments where segment_name='SYS_LOB0000255030C00040$$';OWNER SEGMENT_NAME PARTITION_NAME SEGMENT_TYPE TABLESPACE_NAME HEADER_FILE HEADER_BLOCK BYTES BLOCKS EXTENTS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE FREELISTS FREELIST_GROUPS RELATIVE_FNO BUFFER_------------------------------ ----------------------------- --