Home » RDBMS Server » Server Administration » Max extents reached for LOB Segments
Max extents reached for LOB Segments [message #216300] Fri, 26 January 2007 04:33 Go to next message
kudur_kv
Messages: 75
Registered: February 2005
Member
Hi,

I have a very important table in my database which has a LOB Segment.

The current used extents is very close to the max extents of the segment. I am not sure how to increase the max extents for this segment. If it were an index or a table, I know what to do!

Could you please help me in increasing the max extents value for this lob segment.

Please let me knwo if you need any specific details.

Regards,
KV
Re: Max extents reached for LOB Segments [message #216314 is a reply to message #216300] Fri, 26 January 2007 06:32 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Just increase the tablespace (add more datafiles or resize the existing datafile) which holds the lobsegment.
Re: Max extents reached for LOB Segments [message #216317 is a reply to message #216300] Fri, 26 January 2007 06:51 Go to previous messageGo to next message
kudur_kv
Messages: 75
Registered: February 2005
Member
found the reply myself

alter table <table_name> modity LOB (column_name)(storage(maxextents ####);

Re: Max extents reached for LOB Segments [message #216320 is a reply to message #216317] Fri, 26 January 2007 07:19 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Just wait for a few days Smile
Previous Topic: Need for db_files
Next Topic: Server side TAF using services created using DBCA
Goto Forum:
  


Current Time: Sun Dec 04 23:04:55 CST 2016

Total time taken to generate the page: 0.04282 seconds