Home » RDBMS Server » Server Administration » my issue regarding a tablespace (Oracle 10.2.0.4.0, RedHatLinux-5)
my issue regarding a tablespace [message #592449] Thu, 08 August 2013 08:44 Go to next message
8939513598$
Messages: 103
Registered: July 2013
Location: chennai
Senior Member
Hi Sir,There was a tablespace of size 100MB.That Tablespace is filled and hence throwing an error like "unable to extent".
But verified that there is around 20MB freespace present in the tablespace.what would be the reason behind this error?

Re: my issue regarding a tablespace [message #592457 is a reply to message #592449] Thu, 08 August 2013 09:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Not consecutive free extents.
Complete answer requires more information on the tablespace.

Regards
Michel

[Updated on: Thu, 08 August 2013 09:59]

Report message to a moderator

Re: my issue regarding a tablespace [message #592469 is a reply to message #592457] Thu, 08 August 2013 12:54 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

use COPY & PASTE so we can see what you do & how Oracle actually responds
Previous Topic: Resizing logfiles
Next Topic: unique session id
Goto Forum:
  


Current Time: Thu Mar 28 18:14:41 CDT 2024