Sfrgttk

Do I need to convey a moral for each of my blog post?

Does convergence of polynomials imply that of its coefficients?

Are hand made posters acceptable in Academia?

How to read string as hex number in bash?

Have the tides ever turned twice on any open problem?

How do researchers send unsolicited emails asking for feedback on their works?

How to determine the greatest d orbital splitting?

When did hardware antialiasing start being available?

How to test the sharpness of a knife?

Asserting that Atheism and Theism are both faith based positions

Print a physical multiplication table

What kind of footwear is suitable for walking in micro gravity environment?

What is it called when someone votes for an option that's not their first choice?

Homology of the fiber

Did Nintendo change its mind about 68000 SNES?

Error in master's thesis, I do not know what to do

How to find the largest number(s) in a list of elements, possibly non-unique?

Symbolism of 18 Journeyers

Why do I have a large white artefact on the rendered image?

Why is participating in the European Parliamentary elections used as a threat?

Is this Pascal's Matrix?

"Marked down as someone wanting to sell shares." What does that mean?

Hot air balloons as primitive bombers

Unable to get newly inserted Product's Id using After Plugin for Catalog Product save controller method

ORA-01691 (unable to extend lob segment) even though my tablespace has AUTOEXTEND on

ORA-01692: unable to extend lob segment AUDSYS.SYS_LOB0000091592C00014$$ partition SYS_LOB_P12308 by 128 in tablespace SYSAUXORA-01555: snapshot too old: rollback segment number with name “” too smallORA-01654: unable to extend index <name of the index> by 128 in tablespace <name of the Index tablespace>ORA-01562: failed to extend rollback segment number 11ORA-29339: tablespace block size 16384 does not match configured block sizesORA-01658 on index tablespace when trying to insert into empty table of new databaseOracle IMPDP job ORA-30036 unable to extend segment by 8 in undo tablespace 'UNDOTBS1'Oracle - ORA-01654: unable to extend index in tablespaceORA-01652 : unable to extend temp segment by 128 in tablespace HFDORA_TEMPMassive deviation of tablespace max_size compared to bytes used by segments on that tablespaceORA-01555: Snapshot too old rollback segment with name “” too small error

2

I am getting an error:

ORA-01691: unable to extend lob segment ABC.SYS_LOB0000167347C00131$$ by 1024 in tablespace XYZ

But this is very strange to me because the tablespace has AUTOEXTEND on. What is the likely reason that this happens and how can I overcome it?

Thanks.

oracle tablespaces

share|improve this question

asked Sep 3 '16 at 13:25

Balkrishna RawoolBalkrishna Rawool

111113

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  If that is a small file tablespace, maybe it has reached the 32GB limit?
  
  – a_horse_with_no_name
  Sep 3 '16 at 14:37
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Yes, it is a small file tablespace. And it is very much possible that it has reached 32GB limit. What options do I have now?
  
  – Balkrishna Rawool
  Sep 3 '16 at 15:04
  

  
  
  
  


• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  Add data files.
  
  – tesla747
  Sep 3 '16 at 15:58
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  thanks tesla747 and @a_horse_with_no_name. I'll try that option.
  
  – Balkrishna Rawool
  Sep 4 '16 at 20:10
  

  
  
  
  

add a comment | 

2

I am getting an error:

ORA-01691: unable to extend lob segment ABC.SYS_LOB0000167347C00131$$ by 1024 in tablespace XYZ

But this is very strange to me because the tablespace has AUTOEXTEND on. What is the likely reason that this happens and how can I overcome it?

Thanks.

oracle tablespaces

share|improve this question

asked Sep 3 '16 at 13:25

Balkrishna RawoolBalkrishna Rawool

111113

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  If that is a small file tablespace, maybe it has reached the 32GB limit?
  
  – a_horse_with_no_name
  Sep 3 '16 at 14:37
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Yes, it is a small file tablespace. And it is very much possible that it has reached 32GB limit. What options do I have now?
  
  – Balkrishna Rawool
  Sep 3 '16 at 15:04
  

  
  
  
  


• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  Add data files.
  
  – tesla747
  Sep 3 '16 at 15:58
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  thanks tesla747 and @a_horse_with_no_name. I'll try that option.
  
  – Balkrishna Rawool
  Sep 4 '16 at 20:10
  

  
  
  
  

add a comment | 

I am getting an error:

ORA-01691: unable to extend lob segment ABC.SYS_LOB0000167347C00131$$ by 1024 in tablespace XYZ

But this is very strange to me because the tablespace has AUTOEXTEND on. What is the likely reason that this happens and how can I overcome it?

Thanks.

oracle tablespaces

share|improve this question

asked Sep 3 '16 at 13:25

Balkrishna RawoolBalkrishna Rawool

111113

ORA-01691: unable to extend lob segment ABC.SYS_LOB0000167347C00131$$ by 1024 in tablespace XYZ

share|improve this question

asked Sep 3 '16 at 13:25

Balkrishna RawoolBalkrishna Rawool

111113

share|improve this question

asked Sep 3 '16 at 13:25

Balkrishna RawoolBalkrishna Rawool

111113

asked Sep 3 '16 at 13:25

Balkrishna RawoolBalkrishna Rawool

111113

asked Sep 3 '16 at 13:25

Balkrishna RawoolBalkrishna Rawool

111113

2 Answers
2

active

oldest

votes

5

Autoextensible datafiles still have a size limit.

select file_id, bytes, maxbytes from dba_data_files where tablespace_name = 'XYZ';

Maxbytes is the maximum size of the datafile, it can not grow beyond that. If bytes = maxbytes, you have two options:

1) increase the maximum size (maxbytes) as (15 is the file_id from above query), for example to 10G:

alter database datafile 15 autoextend on maxsize 20G;

Datafiles have a hard limit for the maximum size, it is 2^22 * block_size for smallfile tablespaces, and 2^32 * block_size for bigfile tablespaces.

If you use a tablespace with 8K block size, then the maximum size of your datafile is 32 GB. If your datafile is already at that size, you can not increase it any further, there comes option number two:

2) add a new datafile to the tablespace, for example:

alter tablespace xyz add datafile '/path/to/datafiles/xyz02.dbf' size 100M autoextend on next 100M maxsize unlimited;

share|improve this answer

answered Sep 3 '16 at 18:28

Balazs PappBalazs Papp

26.7k2931

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks @Balazs Papp. Now that I have better understanding of this, I'll try this option.
  
  – Balkrishna Rawool
  Sep 4 '16 at 20:11
  

  
  
  
  

add a comment | 

0

Thank u Boss it is a complete answer.........!!

share

answered 1 min ago

Mostafiz MItulMostafiz MItul

1

New contributor

Mostafiz MItul is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f148747%2fora-01691-unable-to-extend-lob-segment-even-though-my-tablespace-has-autoexten%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

5

Autoextensible datafiles still have a size limit.

select file_id, bytes, maxbytes from dba_data_files where tablespace_name = 'XYZ';

Maxbytes is the maximum size of the datafile, it can not grow beyond that. If bytes = maxbytes, you have two options:

1) increase the maximum size (maxbytes) as (15 is the file_id from above query), for example to 10G:

alter database datafile 15 autoextend on maxsize 20G;

Datafiles have a hard limit for the maximum size, it is 2^22 * block_size for smallfile tablespaces, and 2^32 * block_size for bigfile tablespaces.

If you use a tablespace with 8K block size, then the maximum size of your datafile is 32 GB. If your datafile is already at that size, you can not increase it any further, there comes option number two:

2) add a new datafile to the tablespace, for example:

alter tablespace xyz add datafile '/path/to/datafiles/xyz02.dbf' size 100M autoextend on next 100M maxsize unlimited;

share|improve this answer

answered Sep 3 '16 at 18:28

Balazs PappBalazs Papp

26.7k2931

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks @Balazs Papp. Now that I have better understanding of this, I'll try this option.
  
  – Balkrishna Rawool
  Sep 4 '16 at 20:11
  

  
  
  
  

add a comment | 

5

Autoextensible datafiles still have a size limit.

select file_id, bytes, maxbytes from dba_data_files where tablespace_name = 'XYZ';

Maxbytes is the maximum size of the datafile, it can not grow beyond that. If bytes = maxbytes, you have two options:

1) increase the maximum size (maxbytes) as (15 is the file_id from above query), for example to 10G:

alter database datafile 15 autoextend on maxsize 20G;

Datafiles have a hard limit for the maximum size, it is 2^22 * block_size for smallfile tablespaces, and 2^32 * block_size for bigfile tablespaces.

If you use a tablespace with 8K block size, then the maximum size of your datafile is 32 GB. If your datafile is already at that size, you can not increase it any further, there comes option number two:

2) add a new datafile to the tablespace, for example:

alter tablespace xyz add datafile '/path/to/datafiles/xyz02.dbf' size 100M autoextend on next 100M maxsize unlimited;

share|improve this answer

answered Sep 3 '16 at 18:28

Balazs PappBalazs Papp

26.7k2931

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks @Balazs Papp. Now that I have better understanding of this, I'll try this option.
  
  – Balkrishna Rawool
  Sep 4 '16 at 20:11
  

  
  
  
  

add a comment | 

Autoextensible datafiles still have a size limit.

select file_id, bytes, maxbytes from dba_data_files where tablespace_name = 'XYZ';

Maxbytes is the maximum size of the datafile, it can not grow beyond that. If bytes = maxbytes, you have two options:

1) increase the maximum size (maxbytes) as (15 is the file_id from above query), for example to 10G:

alter database datafile 15 autoextend on maxsize 20G;

Datafiles have a hard limit for the maximum size, it is 2^22 * block_size for smallfile tablespaces, and 2^32 * block_size for bigfile tablespaces.

If you use a tablespace with 8K block size, then the maximum size of your datafile is 32 GB. If your datafile is already at that size, you can not increase it any further, there comes option number two:

2) add a new datafile to the tablespace, for example:

alter tablespace xyz add datafile '/path/to/datafiles/xyz02.dbf' size 100M autoextend on next 100M maxsize unlimited;

share|improve this answer

answered Sep 3 '16 at 18:28

Balazs PappBalazs Papp

26.7k2931

select file_id, bytes, maxbytes from dba_data_files where tablespace_name = 'XYZ';

alter database datafile 15 autoextend on maxsize 20G;

alter tablespace xyz add datafile '/path/to/datafiles/xyz02.dbf' size 100M autoextend on next 100M maxsize unlimited;

share|improve this answer

answered Sep 3 '16 at 18:28

Balazs PappBalazs Papp

26.7k2931

answered Sep 3 '16 at 18:28

Balazs PappBalazs Papp

26.7k2931

answered Sep 3 '16 at 18:28

Balazs PappBalazs Papp

26.7k2931

0

Thank u Boss it is a complete answer.........!!

share

answered 1 min ago

Mostafiz MItulMostafiz MItul

1

New contributor

Mostafiz MItul is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

Thank u Boss it is a complete answer.........!!

share

answered 1 min ago

Mostafiz MItulMostafiz MItul

1

New contributor

Mostafiz MItul is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

Thank u Boss it is a complete answer.........!!

share

answered 1 min ago

Mostafiz MItulMostafiz MItul

1

New contributor

Mostafiz MItul is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

answered 1 min ago

Mostafiz MItulMostafiz MItul

1

New contributor

Mostafiz MItul is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

answered 1 min ago

Mostafiz MItulMostafiz MItul

1

New contributor

Mostafiz MItul is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

answered 1 min ago

Mostafiz MItulMostafiz MItul

1