Home » RDBMS Server » Server Administration » Unable to extend extent
Unable to extend extent [message #246137] Wed, 20 June 2007 01:40 Go to next message
kamragulshan
Messages: 63
Registered: May 2005
Location: Delhi
Member
I have oracle 10gR1 on solaris and database is using ASM. Yesterday i have found the error in alert.log file:

ORA-1653: unable to extend table
ORA-1654: unable to extend index

The error belongs to a particular tablespace TBS01.

The datafile belong to this tablespace is 19GB and autoextend on for this datafile upto 32GB.

I have run the below queries:
SQL> select sum(bytes/1024/1024/1024) from dba_segments;

SUM(BYTES/1024/1024/1024)
-------------------------
994.232666

SQL> select sum(bytes/1024/1024/1024) from dba_free_space;

SUM(BYTES/1024/1024/1024)
-------------------------
212.42511

I have 39 disk of 32GB each for ASM. So the size of ASM is 32x39=1248GB.

SQL> select sum(free_mb/1024) from v$asm_diskgroup;

SUM(FREE_MB/1024)
-----------------
0

SQL> select sum(free_mb/1024) from v$asm_disk;

SUM(FREE_MB/1024)
-----------------
0


But still it is showing this error. I am unable to find out the cause for this issue.

Please tell me the resolve the issue.

Thanks in Advance.


Re: Unable to extend extent [message #246140 is a reply to message #246137] Wed, 20 June 2007 01:51 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So how can we do with what you posted?

Post the lines from your alert.log.
Please read and follow How to format your posts.

Regards
Michel
Re: Unable to extend extent [message #246144 is a reply to message #246137] Wed, 20 June 2007 01:55 Go to previous messageGo to next message
kamragulshan
Messages: 63
Registered: May 2005
Location: Delhi
Member
The message in alert.log file is

ORA-1653: unable to extend table METAINFODB.SI_LINE_INFO by 128 in tablespace TBS01
ORA-1653: unable to extend table METAINFODB.SI_LINE_INFO by 8192 in tablespace TBS01
Wed Jun 20 01:13:54 2007
ORA-1653: unable to extend table METAINFODB.SI_LINE_INFO by 128 in tablespace TBS01
ORA-1653: unable to extend table METAINFODB.SI_LINE_INFO by 8192 in tablespace TBS01
Wed Jun 20 01:13:58 2007
ORA-1653: unable to extend table METAINFODB.SI_LINE_INFO by 128 in tablespace TBS01
ORA-1653: unable to extend table METAINFODB.SI_LINE_INFO by 8192 in tablespace TBS01
ORA-1653: unable to extend table METAINFODB.SI_LINE_INFO by 128 in tablespace TBS01
ORA-1653: unable to extend table METAINFODB.SI_LINE_INFO by 8192 in tablespace TBS01
Wed Jun 20 01:15:00 2007
ORA-1653: unable to extend table METAINFODB.SI_LINE_INFO by 128 in tablespace TBS01
ORA-1653: unable to extend table METAINFODB.SI_LINE_INFO by 8192 in tablespace TBS01
Wed Jun 20 01:15:01 2007
ORA-1653: unable to extend table METAINFODB.SI_LINE_INFO by 128 in tablespace TBS01
ORA-1653: unable to extend table METAINFODB.SI_LINE_INFO by 8192 in tablespace TBS01
ORA-1653: unable to extend table METAINFODB.SI_LINE_INFO by 128 in tablespace TBS01
ORA-1653: unable to extend table METAINFODB.SI_LINE_INFO by 8192 in tablespace TBS01
Wed Jun 20 01:15:13 2007
ORA-1653: unable to extend table METAINFODB.SI_LINE_INFO by 128 in tablespace TBS01
ORA-1653: unable to extend table METAINFODB.SI_LINE_INFO by 8192 in tablespace TBS01

Re: Unable to extend extent [message #246164 is a reply to message #246144] Wed, 20 June 2007 02:42 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Check max(blocks) from dba_free_space where tablespace_name=...

Please read and follow How to format your posts.

Regards
Michel
Previous Topic: Oracle 9i/10g Dropping a datafile from a tablespace
Next Topic: Oracle linux version ibm864 arabic support
Goto Forum:
  


Current Time: Sun Dec 04 14:49:15 CST 2016

Total time taken to generate the page: 0.20284 seconds