-
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 :DRSYS 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
-
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
-
Mr.Hanky!Query!
Hi!
Is the said datafile_id = 38 pointing to the correct tablespace_
name i.e., DRSYS!
Thanks & Regards,
Amit.
