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

Report message to a moderator

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: 26766
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.

Report message to a moderator

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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 01 14:44:55 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.