I just ran into an ORA-01654 error, since my tablespace maxsize was reached.
Hence I increased the datafile size and set it to 4G.
What I'm wondering is whether I also have to redefine the tablespace maxsize to 4G:
Alter tablespace MYTBS maxsize 4000m;
When querying dba_tablespaces I find that maxsize is still at 2000m whereas the data_file listed under dba_data_files is correctly shown with 4000m.
Maybe you can enlighten me with your knowledge!