ORA-01653: unable to extend table
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ORA-01653: unable to extend table

Hybrid View

  1. #1
    Join Date
    Aug 2002
    Posts
    176

    ORA-01653: unable to extend table

    Hi we have a Tablepace whihc has a freesapce of 827.921875 mb
    one of its segments shows

    ORA-01653: unable to extend table

    Its nextextent is 170.859375 mb and the initial is 331.71875 mb. It has only one extent .

    Even if we coalsece the tablespace it does not effect the dba_free_space.

    Oracle verison is 8.1.6 and dictionary managed tableapsce

    Please Advice
    Success Consists of Getting Up Just One More Time Than You've Fallen Down
    Be Blessed

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    01653, 00000, "unable to extend table %s.%s by %s in tablespace %s"
    // *Cause: Failed to allocate an extent for table segment in tablespace.
    // *Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more
    // files to the tablespace indicated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width