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>
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
Output of this query is a script which you should run to move all the
where tablespace_name='SYSTEM' and owner not in('SYS','SYSTEM')