-
Hi!
My users tablespace has one datafile users01.dbf which has autoextend on. I set it to on after the tablespace was created.
Still it is giving error
ORA-1653: unable to extend table EPRO3.ITCDATA by 16 in tablespace USERS
To keep my work going I have manually created User02.dbf for now. But the PRoblem is interesting.
Any Answers....
-
What is the NEXT and MAXSIZE for the autoextend clause. Make sure that your datafile hasn't reached the MAXSIZE the other possibility is there is not enough space in that disk to allocate your NEXT extent.
Sanjay
-
Yes, MAXSIZE was the problem. Thanks a lot Sanjay.
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
|