Auto-extend of tablespaces

[volcano]

Hello, I created a tablespace and did not specify it to be auto-extensible. Now I found the tables in the tablespace grow so fast that often exceed the capacity of the tablespace. What command could I type to change the tablespace to be auto-extensible now?

Thanks!

 

[rbeemadi]

ALTER DATABASE DATAFILE '/path/file.dbf' AUTOEXTEND ON NEXT nM MAXSIZE [UNLIMITED/nM]

 

[dbase77]

Hi,

Beware of setting autoextend ON. You might runnig out of disk space. Unless you have plenty of free space then you can ingore me. If possible take weekly or monthly use of this tablespace so that you can get some kind of statistic.

regards,
dbase77