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

Thread: Ora-1654

  1. #1
    Join Date
    Nov 2000
    Posts
    157

    Ora-1654

    ORA-1654: unable to extend index HR.PAY_RUN_RESULT_VALUES_PK by 8195 in tablespace HRX

    There is 40GB of free space available in that Tablespace.

    I think the index couldnot able to find the contiguous space of 8195.I coalesecd the Tbalespace even after that the same error is popping up.

    Temporarly to resolve the issue we had to increase the tablespace by adding a datafile '/mnt/oraprod/proddata/fs04/hrx18.dbf' of size 2000M.

    Is there any other solution to avoid this issue please??
    ravi

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

    Re: Ora-1654

    Originally posted by cravi

    I think the index couldnot able to find the contiguous space of 8195.
    Yup, that's probably it. Make smaller NEXT extents or convert to system managed LMT.
    Jeff Hunter

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