| Error [message #474043] |
Thu, 02 September 2010 04:43  |
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  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 |
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 |
cookiemonster
Messages: 13959
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 |
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 |
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).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
