-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|