Home » RDBMS Server » Server Administration » Max extent reached
Max extent reached [message #193919] Tue, 19 September 2006 23:22 Go to next message
fakhar55
Messages: 99
Registered: September 2005
Location: UAE
Member
hi all,
ORA-01631: max # extents (505) reached in table GL.GL_INTERFACE_TRK when inserting new rows. How to remove this any help will be greatly appreciated.
Re: Max extent reached [message #193992 is a reply to message #193919] Wed, 20 September 2006 05:50 Go to previous messageGo to next message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
alter table <table-name> storage (maxextents unlimited);

or

alter table <table-name> storage (maxextents 1000);

Br
Kim Anthonisen
Re: Max extent reached [message #194227 is a reply to message #193992] Thu, 21 September 2006 04:22 Go to previous message
fakhar55
Messages: 99
Registered: September 2005
Location: UAE
Member
hi kim,
thanx a lot .It resolved my issue.

Best regards
fakhar.
Previous Topic: SVRMGRL Confusion
Next Topic: Shared server configuration in 10g
Goto Forum:
  


Current Time: Wed Dec 07 08:35:55 CST 2016

Total time taken to generate the page: 0.11123 seconds