Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to extend table in tablespace

Samuel RabiniJan 12 2011 — edited Jan 24 2011
Hi,
I have a Oracle Database 11g Release 11.1.0.6.0 - 64bit Production With the Real Application Clusters option.

I'm receiving the unable to extend table T_DATA in tablespace USER

I'm using ASM.
This is the situation of datafiles of USER tablespace (dimension is in GB):

+DATA/evodb/datafile/users.277.737627613 USERS 9,97265625
+DATA/evodb/datafile/users.275.731805999 USERS 60,97265625
+DATA/evodb/datafile/users.261.662113927 USERS 63,999969482421875
+DATA/evodb/datafile/users.264.705345395 USERS 63,999969482421875
+DATA/evodb/datafile/users.265.698502565 USERS 63,999969482421875
+DATA/evodb/datafile/users.268.718788313 USERS 63,999969482421875

It seems I still have 2 datafile that can grow (maximium size is 63,999969482421875)

This is the situation of DATA group (the one to which USER tablespace belongs):

Group # | Name | Free_mb | Usable_file_mb | total_mb
2 DATA 300051 300051 1134809

And this is the situation of every device belonging to DATA diskgroup:

Path | disk_number | group_name | group_number | header_status| free_mb | os_mb | total_mb
/dev/asm212 13 DATA 2 MEMBER 56627 208500 208500
/dev/asm9 7 DATA 2 MEMBER 12607 48127 48127
/dev/asm6 4 DATA 2 MEMBER 12600 48127 48127
/dev/asm8 6 DATA 2 MEMBER 12595 48127 48127
/dev/asm11 9 DATA 2 MEMBER 13315 51199 51199
/dev/asm211 11 DATA 2 MEMBER 56555 208500 208500
/dev/asm5 3 DATA 2 MEMBER 12611 48127 48127
/dev/asm3 1 DATA 2 MEMBER 12614 48127 48127
/dev/asm12 10 DATA 2 MEMBER 0 5115 5115
/dev/asm7 5 DATA 2 MEMBER 12584 48127 48127
/dev/asm213 12 DATA 2 MEMBER 60138 228352 228352
/dev/asm4 2 DATA 2 MEMBER 12608 48127 48127
/dev/asm10 8 DATA 2 MEMBER 12598 48127 48127
/dev/asm2 0 DATA 2 MEMBER 12599 48127 48127

Why table cannot extend??

And more:
if I try to add a datafile to USER tablespace, I got:

ORA-17502: ksfdcre:4 Failed to create file +DATA
ORA-15041: diskgroup space exhausted
01119. 00000 - "error in creating database file '%s'"

Any suggestion??

thanks in advance,
Samuel
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 21 2011
Added on Jan 12 2011
9 comments
412 views