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

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 - 04:38:28 CDT