SQL> select * from v$version where rownum=1;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod

SQL> create tablespace test datafile 'E:\ORACLE\BASES\MIKA\TEST01.DBF' size 100m;

Tablespace created.

SQL> alter tablespace test offline;

Tablespace altered.

SQL>  create table test (v int) tablespace test;
 create table test (v int) tablespace test
*
ERROR at line 1:
ORA-01542: tablespace 'TEST' is offline, cannot allocate space in it

orcl>
orcl> alter tablespace users offline;

Tablespace altered.

orcl>  create table t1(c1 date) tablespace users;

Table created.

orcl> insert into t1 values(sysdate);
insert into t1 values(sysdate)
            *
ERROR at line 1:
ORA-01542: tablespace 'USERS' is offline, cannot allocate space in it


orcl> select * from v$version;

BANNER
-------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
PL/SQL Release 11.2.0.3.0 - Production
CORE    11.2.0.3.0      Production
TNS for 32-bit Windows: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production

orcl> sho parameter defer

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------
deferred_segment_creation            boolean     TRUE
orcl>

SQL> select * from v$version where rownum=1;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

SQL> create tablespace raja_tbs datafile 'd:\app\raja\oradata\orcl\rajadata.dbf' size 100m;

Tablespace created.

SQL> create table scott.table01(n number) tablespace raja_tbs;

Table created.

SQL> alter tablespace raja_tbs offline;

Tablespace altered.

SQL> create table scott.table02(n number) tablespace raja_tbs;

Table created.

SQL> sho parameter defer;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
deferred_segment_creation            boolean     TRUE
SQL>

orcl> create table t1 (c1 date) tablespace users;

Table created.

orcl> insert into t1 values(sysdate);

1 row created.

orcl> alter tablespace users read only;

Tablespace altered.

orcl> insert into t1 values(sysdate);
insert into t1 values(sysdate)
            *
ERROR at line 1:
ORA-00372: file 4 cannot be modified at this time
ORA-01110: data file 4: 'C:\APP\JOHN\ORADATA\ORCL\DATAFILE\USERS.DBF'


orcl> delete from t1;
delete from t1
            *
ERROR at line 1:
ORA-00372: file 4 cannot be modified at this time
ORA-01110: data file 4: 'C:\APP\JOHN\ORADATA\ORCL\DATAFILE\USERS.DBF'


orcl> drop table t1;

Table dropped.

orcl> --what?? how can that be possible????
orcl>