OraFAQ Forum: Server Administration » Max extents reached for LOB Segments

Home » RDBMS Server » Server Administration » Max extents reached for LOB Segments

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Max extents reached for LOB Segments [message #216300]

Fri, 26 January 2007 04:33

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

Report message to a moderator

Re: Max extents reached for LOB Segments [message #216314 is a reply to message #216300]

Fri, 26 January 2007 06:32

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

Re: Max extents reached for LOB Segments [message #216317 is a reply to message #216300]

Fri, 26 January 2007 06:51

kudur_kv
Messages: 75
Registered: February 2005

Member

found the reply myself

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

Report message to a moderator

Re: Max extents reached for LOB Segments [message #216320 is a reply to message #216317]

Fri, 26 January 2007 07:19

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Just wait for a few days Smile

Report message to a moderator

Previous Topic:	Need for db_files
Next Topic:	Server side TAF using services created using DBCA

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 04:21:30 CDT 2024