Home » RDBMS Server » Server Administration » Unable to extend extent (2 Merged) (oracle 10g, 10.2.0.4, O.E.L)
Unable to extend extent (2 Merged) [message #566511] Sun, 16 September 2012 08:44 Go to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Hello all,

When ever error occurred as "Unable to extend extent", we do add either datafiles or increase the size (autoextend on).
But in a interview, i was asked to handle the error without increasing size/adding new datafiles.

Please let me know, how can i handle this error without increasing size?

Waiting for your kind response...

Regards,
Ishika
Re: Unable to extend extent [message #566513 is a reply to message #566511] Sun, 16 September 2012 09:13 Go to previous messageGo to next message
BlackSwan
Messages: 26606
Registered: January 2009
Location: SoCal
Senior Member
>Please let me know, how can i handle this error without increasing size?
use different tablespace that has sufficient free space.
Re: Unable to extend extent (2 Merged) [message #566515 is a reply to message #566511] Sun, 16 September 2012 09:45 Go to previous message
Michel Cadot
Messages: 66644
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The first answer should be "there is no error "unable to extend extent"".
An extend has a fixed size, do not increase or decrease.

Regards
Michel
Previous Topic: Unable to claim space for the operating system
Next Topic: Stats gather-LAST_ANALYZED column is not updated (merged)
Goto Forum:
  


Current Time: Sun Oct 20 09:42:39 CDT 2019