Home -> Usenet -> comp.databases.oracle -> Re: tablespace SYSTEM used by others user, not sys. Help!

Re: tablespace SYSTEM used by others user, not sys. Help!

From: x <x_at_x.hr>
Date: Thu, 3 Jun 2004 11:38:28 +0200
Message-ID: <c9mrg5$6t5$1_at_ls219.htnet.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.
Received on Thu Jun 03 2004 - 11:38:28 CEST












Original text of this message