DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002

    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
    Madrid, Spain
    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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.