SQL> alter database datafile '/u01/app/oracle/oradata/orcl/ts1.02.dbf' autoextend on next 1m maxsize 100m;
Database altered.
SQL> alter database datafile '/u01/app/oracle/oradata/orcl/ts1.02.dbf' autoextend off;
Database altered.
SQL> alter tablespace ts1 read only;
Tablespace altered.
SQL> select tablespace_name,file_name,ceil(bytes/1024/1024) mb
from dba_data_files order by 1;
SQL> select tablespace_name,status from dba_tablespaces;
TABLESPACE_NAME STATUS
------------------------------ ---------
SYSTEM ONLINE
UNDOTBS1 ONLINE
SYSAUX ONLINE
TEMP ONLINE
USERS ONLINE
EYGLE ONLINE
TS1 READ ONLY
7 rows selected.
SQL> alter tablespace ts1 read write;
Tablespace altered.
SQL> alter tablespace ts1 offline;
Tablespa