Re: reclaiming space from SYSTEM tablespace.

why is it so large ? had there any users been created with no given own tablespace; SYSTEM is the default:

then take all the users except sys, system which own objects in system tablespace and move them to other tablespaces

alter user <usr1> default tablespace <tablespace1> ; atler user <...> default tablespace <...>;

select 'alter table '|| owner||'.' ||table_name || ' move tablespace '|| <tablespace1> ||';' where owner = <usr1> ;

after finishing that action you possibly can shrink the datafile ...

--
Posted via http://dbforums.com