Urgent: 'ORA-01653: unable to extend table xyz.Products by 8192
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Urgent: 'ORA-01653: unable to extend table xyz.Products by 8192

Hybrid View

  1. #1
    Join Date
    Oct 2006
    Posts
    175

    Urgent: 'ORA-01653: unable to extend table xyz.Products by 8192

    Hi all
    I had run a bulk procedure with create and insert statements yesterday. But its throwing 'ORA-01653: unable to extend table xyz.Products by 8192 in tablespace xyz' now after running more than half of the procedure. Please advice how I can overcome this situation without having to restart the procedure as it takes lots of hours to complete and I am running out of dates.

    Thanks,
    gtcol

  2. #2
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245
    your tablespace doesnt have free space to accomodate inserts you are doing .
    increase some space in that perticuler tablespace.
    Your procedure must have come out with said error add space and re-run procedure..
    Rgds
    Parag

  3. #3
    Join Date
    Oct 2006
    Posts
    175
    Quote Originally Posted by paragp1981
    your tablespace doesnt have free space to accomodate inserts you are doing .
    increase some space in that perticuler tablespace.
    Your procedure must have come out with said error add space and re-run procedure..
    I do understand its space issue. Any ideas I can add more datafiles and not have to rerun the procedure??

    Thanks,
    gtcol

  4. #4
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349
    You have to rerun after adding datafile or modifying storage parameter of tablespace.
    http://www.perf-engg.com
    A performance engineering forum

  5. #5
    Join Date
    Oct 2006
    Posts
    175
    Thanks Malay&Parag,
    Did exactly the way you have advised. Couldn't find any other workaround.

    Rgds,
    gtcol

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