| Stumped about an ORA-01683 error [message #463420] |
Thu, 01 July 2010 04:51  |
monkeyman
Messages: 2
Registered: July 2010
|
Junior Member |
|
|
Hi,
I am really stumped on a problem. I am getting an ORA-01683 error: "unable to extend index Persons.DOB partition DOB_S10 in tablespace Employees.
The tablespace is sized at 30G, is locally managed and autoallocated. According to OEM only 6G is being taken up. That is, there should be plenty of free space.
Looking at DBA_Extents doesn't show that it is fragmented (biggest table is 4.5GB, the remainder is small) - after all it's being managed locally. Various tables (and indexes) are partitioned.
So I'm scratching my head. What could be chewing up the space or what can I look for to help me solve this problem. 
Harold.
|
|
|
|
|
|
|
|
| Re: Stumped about an ORA-01683 error [message #463439 is a reply to message #463437] |
Thu, 01 July 2010 06:24  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
First try to execute:
EXECUTE DBMS_SPACE_ADMIN.TABLESPACE_VERIFY('<your tablespace>')
If it does not work then execute:
begin
for rec in (select header_file, header_block from dba_segments where tablespace_name = '<your tablesace>')
loop
execute immediate
'begin DBMS_SPACE_ADMIN.SEGMENT_VERIFY (''<your tablespace>'', rec.header_file, rec.header_block); end;';
end loop;
end;
/
If this still does not fix the problem use:
EXECUTE DBMS_SPACE_ADMIN.TABLESPACE_REBUILD_BITMAPS('<your tablespace>');
Regards
Michel
[Updated on: Thu, 01 July 2010 06:28] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
