Re: reclaiming space from SYSTEM tablespace.

From: Ray Teale <ray_at_BLAHholly.com.au>
Date: Tue, 8 Apr 2003 11:26:42 +1000
Message-ID: <zwpka.41$QE2.2578@nnrp1.ozemail.com.au>

Ok - I worked it out.  I didn't hink you could resize the system datafile
but it seems you can.
Thanks for your help.

Ray

"Ray Teale" <ray_at_BLAHholly.com.au> wrote in message news:vYnka.28$QE2.1863_at_nnrp1.ozemail.com.au...
> The tablespace is mostly empty. How do I shrink the datafile?
>
> Ray
> "osy45" <member18536_at_dbforums.com> wrote in message
> news:2736728.1049694641_at_dbforums.com...
> >
> > 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
>
>
Received on Mon Apr 07 2003 - 20:26:42 CDT