From: x@x.hr   
      
   You should move all tables and rebuild all indexes to different tablespace.   
      
   something like:   
      
   alter table my_table move tablespace users;   
      
   alter index my_index rebuild tablespace users;   
      
   Use dba_tables and dba_indexes to find out which tables and indexes are in   
   system tablespace. You could use it like this:   
      
      
   select 'alter table ' || table_name || ' move tablespace users;'   
   from dba_tables   
   where tablespace_name='SYSTEM' and owner not in('SYS','SYSTEM')   
      
   Output of this query is a script which you should run to move all the   
   tables. Do the same for indexes.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)