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