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

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

Threaded View

  1. #3
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340
    Yes PAVB
    we have done that in order to fix it temporarily

    But still I am wondering why locally managed tablespace is not able to find a large enough area of free contiguous space in which to fit the next extent , still we have 80% free space in the tablespace

    Current extent details for that object.

    SQL> select TABLE_NAME,next_extent,pct_increase from dba_tables where TABLE_NAME='AUDIT_DDL_LOG';

    TABLE_NAME NEXT_EXTENT PCT_INCREASE
    ------------------------------ --------------------- -------------------------
    AUDIT_DDL_LOG 1048576
    Last edited by gopu_g; 08-18-2011 at 05:01 AM.
    Thanks/Gopu

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