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: 59403
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: 22901
Registered: January 2009
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: Mon Oct 20 14:05:43 CDT 2014

Total time taken to generate the page: 0.08266 seconds