9 Replies Latest reply: Jan 24, 2011 5:48 AM by Samuel Rabini RSS

    Unable to extend table in tablespace

    Samuel Rabini
      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