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

Thread: ORA-03232 Error!Unable to allocate 15 blocks of extents from tablespace 38!

  1. #1
    Join Date
    Feb 2001
    Posts
    286
    Hi Eric!

    Yes!Life is Ok as of now!Thanks!How's life there with you!Hope all well!

    Working on Oracle v8i with OS as NT!

    I have this problem:

    My users are running Forms v6i & Reports D2K v6i on a 2 GB Database.
    Suddenly this error occured:

    ORA-03232-UNABLE TO ALLOCATE 15 BLOCKS OF EXTENTS FROM TABLESPACE 38.
    Now how should I find out Tablespace name 38 and which users are working on it.

    I had queried from DBA_DATA_FILES and got to know the following:

    SELECT FILE_ID,FILE_NAME,TABLESPACE_NAME
    FROM DBA_DATA_FILES
    WHERE FILE_ID = 38;

    I got the result RSYS TABLESPACE NAME AND FILE_ID = 38 location:
    D:\ORACLE\ORADATA\PVPL\DR01.DBF.

    Now what should I do as I have resized the above datafile from 20m
    to 25m and made the maxextents unlimited but still the users complain about the same error.

    Please advise!

    This is most urgent as I am at client's place.

    Regards,

    Amit
    Oracle DBA (OCP) v8i,v9i

  2. #2
    Join Date
    Jan 2001
    Posts
    3,134
    ORA-03232 unable to allocate an extent of string blocks from tablespace string

    Cause: An attempt was made to specify a HASH_MULTIBLOCK_IO_COUNT value that is greater than the tablespace's NEXT value.

    Action: Increase the value of NEXT for the tablespace using ALTER TABLESPACE DEFAULT STORAGE or decrease the value of HASH_MULTIBLOCK_IO_COUNT.


    Does this help?

    MH
    I remember when this place was cool.

  3. #3
    Join Date
    Feb 2001
    Posts
    286

    Mr.Hanky!Query!

    Hi!

    Is the said datafile_id = 38 pointing to the correct tablespace_
    name i.e., DRSYS!

    Thanks & Regards,

    Amit.

    Oracle DBA (OCP) v8i,v9i

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