Errro while Rebuilding
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Errro while Rebuilding

  1. #1
    Join Date
    May 2001
    Location
    Delhi
    Posts
    340
    Hi,

    I was rebuilding an Index for a BIG Table and encountered following error :


    ORA-01652: unable to extend temp segment by 8
    Tablespace PSAPTEMP#

    Do I need to to INcrease the size of myTemporary Tablespace ?

    Vijay
    --------------------------
    The Time has come ....

  2. #2
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    Check if there is enough space remaing in TEMP tablespace, else you need to add..

    Sameer

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