ORA-01653: unable to extend table by 128 in tablespace SYSUTIL - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 17 of 17

Thread: ORA-01653: unable to extend table by 128 in tablespace SYSUTIL

  1. #11
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,973
    You might also try alter tablespace SYSUTIL coalesce;
    this space intentionally left blank

  2. #12
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,973
    Quote Originally Posted by PAVB View Post
    Check fragmentation.
    Check fragmentation???? How old fashioned!!!!

    Do we still use VT's for our terminal sessions?
    this space intentionally left blank

  3. #13
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    339
    Quote Originally Posted by gandolf989 View Post
    So it could be that you need to do PURGE DBA_RECYCLEBIN; to free up space in your tablespace.

    Good answer, surely we will check it
    Thanks/Gopu

  4. #14
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    339
    Quote Originally Posted by gandolf989 View Post
    You might also try alter tablespace SYSUTIL coalesce;

    We have tried that, but did't help, Even we have suggested the same from Oracle first and after that they have came up with this as a bug, so we are just waiting to release that, thanks a lot for your valuable answer, i will go with your suggestion.
    Thanks/Gopu

  5. #15
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,973
    You should check the PCT_INCREASE for the ORAAUDIT.AUDIT_DDL_LOG table. If it is set high it will try to grow the size of each new extent.

    select PCT_INCREASE from dba_tables
    where owner='ORAAUDIT' and
    table_name='AUDIT_DDL_LOG';
    this space intentionally left blank

  6. #16
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    339
    Thanks gandolf
    Thanks/Gopu

  7. #17
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by gandolf989 View Post
    Check fragmentation???? How old fashioned!!!!

    Do we still use VT's for our terminal sessions?
    you made may day man - I'm an old fart - LOL
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

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