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:
WHERE FILE_ID = 38;
I got the result :DRSYS TABLESPACE NAME AND FILE_ID = 38 location:
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.
This is most urgent as I am at client's place.
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?
Is the said datafile_id = 38 pointing to the correct tablespace_
name i.e., DRSYS!
Thanks & Regards,