This seems a little bizzare. Could someone explain the below phenomenon?

I created a tablespace and moved the underlying datafile. Yet I am able to insert rows without errors (none in the alertlog..except when the smon wakes up)! What's going on here?

It's a 9.2.0.4..and the tablespace is locally managed..not that it should make a difference.
Thanks, Anand

SQL> create tablespace JUNK datafile '/u12/oradata/TESTRMAN/junk01.dbf' size 1M;

Tablespace created.

SQL> create table junk_table (a varchar2(30)) tablespace junk;

Table created.

SQL> !mv /u12/oradata/TESTRMAN/junk01.dbf /u12/oradata/TESTRMAN/junk01.dbf.o

SQL> insert into junk_table (select table_name from dict);

1221 rows created.

SQL> commit;


SQL> select sum(bytes) from dba_segments where segment_name='JUNK_TABLE';

SUM(BYTES)
----------
65536

SQL> select distinct(tablespace_name) from dba_segments where segment_name='JUNK_TABLE';

TABLESPACE_NAME
--------------------------------------------------------------------------------
JUNK


SQL> insert into junk_table (select table_name from dict);

1221 rows created.

SQL> commit;

Commit complete.

SQL> select sum(bytes) from dba_segments where segment_name='JUNK_TABLE';

SUM(BYTES)
----------
131072