Unable to extend table by 170368 in tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Unable to extend table by 170368 in tablespace

  1. #1
    Join Date
    Nov 2000
    Posts
    3

    Red face

    I'm a new admin. While loading data in thru SQL-Loader in 8i Database, the following message appeared in the log file and loading stopped in the middle. I know its a simple problem.. can anyone help me with the possible solutions. Thanks. The message...."unable to extend table [table_name] by 170368 in tablespace [tablespace_name]"

  2. #2
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    Your tablespace is full. Increase the size of it and you should be able to import. Or if it is # extents issue, increase it.
    Thanks
    Kishore Kumar

  3. #3
    Join Date
    May 2001
    Posts
    31
    Another thing to try is to decrease the NEXT extent size on the table and set PCTINCREASE to 0 so it doesn't try to allocate larger and larger extents.

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