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 RSYS 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.
Oracle DBA (OCP) v8i,v9i
Click Here to Expand Forum to Full Width