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.
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.
Yes, MAXSIZE was the problem. Thanks a lot Sanjay.
Click Here to Expand Forum to Full Width