Hi Tom,

I suspect a ALTER TABLE MOVE actually Drops the table at some
point as table statistics go missing. (Test Case results follow)

I have tried SQL_TRACE and LOG_MINER to verify my theory
Is there anyway you know that would tell me what Oracle is actually
running behind the scenes

Well done on a great book it has been VERY helpful.
I recommend it as a must have for anyone working with Oracle.

Regards

Jim

Connected to:
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production

SQL> create table test_move as select * from dual;

Table created.

SQL>
SQL> analyze table test_move compute statistics;

Table analyzed.

SQL>
SQL> select to_char(last_analyzed,'DD-MON-YYYY HH24:MI:SS')
2 from dba_tables
3 where table_name = 'TEST_MOVE';

TO_CHAR(LAST_ANALYZE
--------------------
24-SEP-2001 13:50:52

SQL>
SQL> alter table test_move move tablespace t_various1;

Table altered.

SQL>
SQL> select to_char(last_analyzed,'DD-MON-YYYY HH24:MI:SS')
2 from dba_tables
3 where table_name = 'TEST_MOVE';

TO_CHAR(LAST_ANALYZE
--------------------


SQL>