-
Able to perform inserts on 'corrupted' tablespace - missing d/f
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|