Oracle ora-01654-ora-01653: Table Attachment cannot be extended by 1024 (in table space USERS)

1. View Table Space usage

SELECT T.tablespace_name,d.file_namefromWHERE  =  ORDER by Tablespace_name,file_name

2. Extended space (maximum 32GB limit for individual files)

ALTER DATABASE datafile ' D:\APP\ADMINISTRATOR\ORCL\aaa. DBF '
Autoextend on NEXT 100M MAXSIZE 40960M;

Error Reporting-
The maximum file size of block (5242880) in the Ora-03206:autoextend clause is out of range
03206.00000-"Maximum file size of (%s) blocks in autoextend clause are out of range"
*cause:the maximum file size for a autoextendable file has
Exceeded the maximum number of blocks allowed.
*action:reduce the size and retry.

3. Add extension Files

ALTER tablespace USERS ADD datafile
' D:\APP\ADMINISTRATOR\VIRTUAL\ORADATA\ORCL\abc. DBF ' SIZE 1024M autoextend on NEXT 200M MAXSIZE 32760M;

Oracle ora-01654-ora-01653: Table Attachment cannot be extended by 1024 (in table space USERS)