Error [message #474043] |
Thu, 02 September 2010 04:43 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ajaykumarkona
Messages: 399 Registered: August 2010
|
Senior Member |
|
|
Hi Experts,
While I am running some SQL query I am getting the following error
unable to extend table SB.CERTIFICATION_H by 16 in
tablespace DATA
What is the resolution for this please help me.
It is very very urgent for me.
Your earliest response will be very helpful to me.
Thanks
|
|
|
|
Re: Error [message #474045 is a reply to message #474044] |
Thu, 02 September 2010 05:03 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
ALWAYS post the complete error message.
ORA-01653: "unable to extend table %s.%s by %s in tablespace %s"
*Cause: Failed to allocate an extent of the required number of blocks for
a table segment in the tablespace indicated.
*Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more
files to the tablespace indicated.
The more complete is your question, the faster you get an appropriate answer.
So if it is very very urgent then post a very very complete question.
Read OraFAQ Forum Guide you will know how to do it, especially also concernng Oracle version.
Regards
Michel
[Updated on: Thu, 02 September 2010 05:05] Report message to a moderator
|
|
|
|
|
Re: Error [message #474064 is a reply to message #474049] |
Thu, 02 September 2010 09:14 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ajaykumarkona
Messages: 399 Registered: August 2010
|
Senior Member |
|
|
I want to find the used and free tablespace for DATA tablespace I have used the following query .
But I did,t get any output even DATA tablespace is there.
select TABLESPACE_NAME, BYTES_USED/1024, BYTES_FREE/1024 from V$TEMP_SPACE_HEADER
WHERE tablespace_name LIKE '%DATA%';
Please help me.
|
|
|
|
Re: Error [message #474068 is a reply to message #474064] |
Thu, 02 September 2010 09:22 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Unsurprising since that view is for temporary tablespaces.
Maybe you should try querying the views Michel told you to use.
|
|
|
Re: Error [message #474079 is a reply to message #474068] |
Thu, 02 September 2010 10:16 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ThomasG
Messages: 3212 Registered: April 2005 Location: Heilbronn, Germany
|
Senior Member |
|
|
Also, what's the point of looking if there is free space when Oracle already told you through the error that there isn't?
|
|
|
Re: Error [message #474110 is a reply to message #474079] |
Thu, 02 September 2010 12:30 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
I'm going to hazard a guess that the OP will see total free space as having enough, not aware that Oracle need contiguous free space to make a new extent, which in this case is probably 131072 bytes (with 8k blocksize).
|
|
|